Conditional Formatting for Blank Cells

I have set up some rules under Format->Conditional formatting for a column of cells. One of the rule I am trying to set is that "If the cell is blank(or has null/missing value) then highlight it with Red color". I did setup the rule but it is not working.

Any ideas/suggestions?

Assuming you are applying the format to cell A1, use this formula in the conditional format:

=A1="" Then format accordingly.

Originally Posted by BigBas

Assuming you are applying the format to cell A1, use this formula in the conditional format:

=A1="" Then format accordingly.

Thanks for your reply. Actually I feel like a stupid to ask the question. After reading your reply it striked me that how will the color show if the cell itself is blank....

So I think what I will be looking now is to change the background color to red instead of the font color...can I do that? I don;t see any option in the Conditional Formatting Dialog Box which will allow me to change the background color.

THanks

Originally Posted by modest_16081982

Thanks for your reply. Actually I feel like a stupid to ask the question. After reading your reply it striked me that how will the color show if the cell itself is blank....

So I think what I will be looking now is to change the background color to red instead of the font color...can I do that? I don;t see any option in the Conditional Formatting Dialog Box which will allow me to change the background color.

THanks

Ok, I got answer..Thank you very much for your help.....