Conditional formatting blank cells

[Guest]

hi,

its very easy question but I just dont know how, pls help!
I wanna conditional format range of cells if they are blank - turn yellow,
otherwise red. But I tried [ Cell is - equal to - ""] doesnt work.
Pls adv.

thx

 

[Peo Sjoblom]

Select the range and then use the active cell (the cell that is not
blue/grey), e.g. if you select A1:A10 starting from A1 then A1 will be the
active cell, then use =A1=""
Having said that using cell is equal to "" will work as well, are the cells
not blank but pseudo blank like a space? If so use

=TRIM(A1)=""

or cell equal to space

--
Regards,

Peo Sjoblom

(No private emails please)

 

[cafe]

Try: Formula Is and type =A1="" (Highlight the range you want to
format before doing the formula and notice that the A1 is not absolute
referece.

Regards,

Cafe