Thread: If cell is blank, then cell is red

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!!!

Hi! You need conditional formatting on cell I9.
http://www.officearticles.com/excel/...soft_excel.htm

Your formula:

=isblank(I9)

*******************
~Anne Troy

www.OfficeArticles.com


"denisesnews" <denisesnews@discussions.microsoft.com> wrote in message
news:D1A93C99-D942-48B1-98B8-B616B59FFC49@microsoft.com...
> 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

"denisesnews" <denisesnews@discussions.microsoft.com> wrote in message
news:D1A93C99-D942-48B1-98B8-B616B59FFC49@microsoft.com...
| 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!!!