View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tilu tilu is offline
external usenet poster
 
Posts: 1
Default trouble with conditional formatting

I am trying to conditionally format any cell over the number 20. But when I
apply my code I get text included. I can't seem to figure out how to eliminat
the formatting from the cells in the range that contain text.

HELP!!!


=================================================
For Each cell In xlRng '.Range("A4:A500")
If cell.Value 20 And cell.Value Then cell.Interior.ColorIndex = 3
Next