Conditional Format Cell

A

Anti-Geniuz

I have excel 200 and am having issues doing this. I need
to create a cell that when empty would be yellow but when
its typed in I need it the backgroud to change to white. I
tried a conditional format from the menu (IF Cell Value
equals "" then yellow).How can I do this? Am I messing
something up on the Conditional FOrmat or do I need to try
something else. Please Advise. Thanks
 
F

Frank Kabel

Hi
in the conditional format dialog chosse "Formula" in the listbox. Then
enter the following formula (assuming that your taget cell is A1):
=A15=""
and set the background to yellow

Hope this helps
Frank
 
B

Bob Phillips

Just go in to Format>Conditional Formatting, select a test of equal, and a
value of ="", click Format, select the Patterns tab and choose your colour.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top