PDA

View Full Version : [SOLVED] Conditional Format for ISBLANK



Anne Troy
03-28-2005, 02:31 PM
If the cell is blank, I want to fill it yellow.

Must be a formula, huh?

isblank(b2) doesn't seem to work.

How?

Jacob Hilderbrand
03-28-2005, 02:36 PM
B2=""

IsBlank should work as well, but make sure you select Formula. Also the cell must be blank and not have a formula that is just returning a "".

Anne Troy
03-28-2005, 02:43 PM
Duh.

Entering the = sign is particularly helpful.

:)

Jacob Hilderbrand
03-28-2005, 02:45 PM
Usually :)

:beerchug: