Don't need to test for TRUE as ISBLANK returns TRUE or FALSE

=NOT(ISBLANK($A1))

=ISBLANK($A1)



--

HTH

RP
(remove nothere from the email address if mailing direct)


"pinmaster" wrote
in message ...

Hi,
Yes, first select your row then in your conditional formatting select
"formula is" from the drop down menu and type:
=ISBLANK($A1)=FALSE
or
=ISBLANK($A1)=TRUE
depending on weather you want the condition to apply when your cell is
blank or non blank.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile:
http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=489601