View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Conditional Fornmatting Text and numbers

If you want to highlight fields which are TEXT i.e. are not blank or numeric
, use:

=TEXT($A1) for your CF

HTH

"Wanna Learn" wrote:

Hello this is my conditional formating = " " and this works fine except
that when there is a number in the cell it does not work. How can I do this
without having to convert the numbers to text? thanks