View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
apache007 apache007 is offline
external usenet poster
 
Posts: 36
Default Conditional Formating, contain space

Hi All,

How do I HIGHLIGHT a block of data that CONTAIN space??

For an Example, COLOUMN A1-A1000 contains TEXT data.
I would like to highlight those cells that contains data.

Thanks in advance.