View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sameoldcalvin sameoldcalvin is offline
external usenet poster
 
Posts: 9
Default Conditional formatting excluding empty cells

use a formula to determine which cells to format -- an option in
conditional format

in the formula, use =isblank (A1)

when the formula return true, the selected format will be
applied....and that should highlight the blank cells