Thanks, but when I do that, it just highlights all my values. I go to
CF, paste the code in (my data starts in A2 so I change it to $A2),
change the fill color to yellow, and hit OK and all the rows that I
highlight turn yellow. Any other suggestions?