Conditional Format Cell

  • Thread starter Thread starter Anti-Geniuz
  • Start date Start date
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
 
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
 
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)
 
Back
Top