Highlighting Cells

P

perezianda

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!
 
G

Gary''s Student

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
 
G

Gord Dibben

CF will work.

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


Gord Dibben MS Excel MVP
 
Top