View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default Conditional Formatting

Hi Group,

I have a range of cells (H10:H24) that contain a 'nested IF-OR formula'
that returns either blank or a value.

How do I set conditional formatting to have the cell not filled if
the formula returns blank but filled if it returns a value?

Thanks for any help
Martin