View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Breitenbach
 
Posts: n/a
Default conditional formatting:highlight row based on blank or non-blank c

highlight entire row a. select conditional formatting and do formula is
=isblank(a1)

adjust for your cell and row

hth,
Dave
"Nat Maxwell" wrote:

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!