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? ; )

Signature
StompS
Portland, OR
http://www.geocities.com/pdxinvestr/Stomps.html
Dave Peterson - 17 Jan 2006 21:33 GMT
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.
> 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
[quoted text clipped - 18 lines]
> Portland, OR
> http://www.geocities.com/pdxinvestr/Stomps.html

Signature
Dave Peterson