View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Owen P Owen P is offline
external usenet poster
 
Posts: 1
Default How to colour highlight empty cell

I have a worksheet with many cells that need to be address individually,
either numerically or otherwise. How do I conditionally highlight cells that
have not been addressed? A cell that contains the numeric value 0 (zero) has
been address, whereas an empty cell has not. It is a pain visually scanning.
It is also an option to highlight cells that have been address either
numerically (including 0) or otherwise.

Thanks Guys and Gals if you could help