View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karenobrn Karenobrn is offline
external usenet poster
 
Posts: 2
Default coloring a cell if blank

I would like to format a column so that if no data has been entered in a cell
in that column then the cell would be colored or marked somehow. Is this
possible? I have tried Conditional Formatting but it only colors the cell if
there is data in that cell... I want to do the opposite.

Thanks
Karen