Highlighting Cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

perezianda - 19 Oct 2006 23:10 GMT

If I have a colomn of gray cells, how can I have them go white when any data
is entered in that cell? Conditional formating isn't working. Thanks in
advance!

Reply to this Message

Gary''s Student - 19 Oct 2006 23:27 GMT

Say its column C.

1. clear all formats in column C

2. In C1 use conditional formatting
..Formula is =C1=""
and pick gray as the background color

3. Copy the format down the column

Whenever you enter a non-blank in column C the gray will go away

Signature

Gary's Student

> If I have a colomn of gray cells, how can I have them go white when any data
> is entered in that cell? Conditional formating isn't working. Thanks in
> advance!

Reply to this Message

Don Guillett - 19 Oct 2006 23:27 GMT

cf
cells not equal ""

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> If I have a colomn of gray cells, how can I have them go white when any
> data
> is entered in that cell? Conditional formating isn't working. Thanks in
> advance!

Reply to this Message

Gord Dibben - 19 Oct 2006 23:39 GMT

CF will work.

See answer in the other group you multi-posted to.

Gord Dibben MS Excel MVP

>If I have a colomn of gray cells, how can I have them go white when any data
>is entered in that cell? Conditional formating isn't working. Thanks in
>advance!

Reply to this Message