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)


"kalz" wrote in message
...
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