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
|