Highlighting Cells

[Guest]

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!

 

[Guest]

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

 

[Don Guillett]

cf
cells not equal ""

 

[Gord Dibben]

CF will work.

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


Gord Dibben MS Excel MVP