Does anyone know if, and how, is possible to use Conditional Formatting
feature to automatically highlight the whole row if a specific cell in that
row is non-blank (or blank)?
Thank you!

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

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