conditional formatting:highlight row based on blank or non-blank c
 

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!

conditional formatting:highlight row based on blank or non-blank c
 

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

conditional formatting:highlight row based on blank or non-blank c
 

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