Conditional Formatting problem

[StompS]

I would like a cell to have a background color of yellow if it is empty (ie:
neeeds data input). Once it has data, the background turns off. I used two
conditions in the conditional format command and it doesn't appear to be
working. I used

(cell value) (is equal to) then typed in 2 double quotes with no space in
between for the condition "yellow"

then, condition 2

(cell value) (is not equal to) then typed in the same as above for the
condition "no fill"

I thought it seemd simple enough and it appeared to work at first but then
stopped working.

How do you guys put up with us newbies? ; )

 

[Dave Peterson]

Format the cell the way you like and you can use just one conditional formatting
rule.

Select the cell
format|Conditional formatting
cell value is Equal to =""

and format it nicely.