If cell is blank, then cell is red

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am an Excel 2002 User. I am trying to create a sheet that has the cell I9
blank. I want the cell to be red for a user to see it and once they fill it
text in that cell, the cell will turn white with the black text. something
like = (IF(ISBLANK(I9)),then cell red, the rest I don't know. Please help
asap... Thanks!!!
 
Try using Conditional Formatting - it's in the Format Menu.
Select Cell I9.
Go Format/Conditional Formatting
Where it says "Cell Value Is", click the drop down and select "Formula Is".
In the next box type =ISBLANK($I$9)
Then click the Format.. button, select the Patterns tab, and click red.
That should do it.
Rgds,
ScottO

| I am an Excel 2002 User. I am trying to create a sheet that has the cell
I9
| blank. I want the cell to be red for a user to see it and once they fill
it
| text in that cell, the cell will turn white with the black text.
something
| like = (IF(ISBLANK(I9)),then cell red, the rest I don't know. Please
help
| asap... Thanks!!!
 
Back
Top