Conditional formatting blank cells
 

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

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

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


--
cafe
------------------------------------------------------------------------
cafe's Profile: http://www.excelforum.com/member.php...o&userid=16145
View this thread: http://www.excelforum.com/showthread...hreadid=395216