Highlight empty cells

**MrEnigma** · 10-11-2008, 01:09 AM

I have a workbook, which some cells that are emty, I would like to highlight these cells, but as soon as some data is entered into the cell, I would like the highlight to be removed.

Thanks in Advance

**josnah** · 10-11-2008, 02:38 AM

try conditional formatting...

Select Cell A1
Click Formula Is and then enter the formula : "=isblank(A1)"
Select the formatting you want to apply when the formula returns the value TRUE.

See picture attached...

**MrEnigma** · 10-12-2008, 03:55 PM

I am a noob at this, where is formula is??

**sglife** · 10-12-2008, 08:17 PM

Fomat > conditional formatting,
Then you see the first box is "cell value is "
Select from the list, there is "Formula is "

**raghunath_jb** · 07-23-2012, 03:22 PM

Does this work in Excel 2003? I tried your formula, but couldn't get it to work!

**Cutter** · 07-23-2012, 04:15 PM

Hello raghunath_jb, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.