Highlighting Cells
 

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!

Highlighting Cells
 

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
--
Gary's Student


"perezianda" wrote:

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!

Highlighting Cells
 

cf
cells not equal ""

--
Don Guillett
SalesAid Software

"perezianda" wrote in message
...
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!

Highlighting Cells
 

CF will work.

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


Gord Dibben MS Excel MVP

On Thu, 19 Oct 2006 15:10:02 -0700, perezianda
wrote:

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!