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

[Guest]

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!

 

[pinmaster]

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

 

[Bob Phillips]

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)