Hi,

I am trying to get my head around the conditional formatting tool but I seem
to be having a bit of a problem, I have a list columd of data that looks a
bit like this

117.4998
84.3664
117.5
117.922
116.978

I want to highlight the figures where the data is above 105.0 but no matter
how I type the CountIF statement in nothing gets highlighted.
My code looks like :- =COUNTIF($A$2:$A$500,A2)105.0
When I go back to check the formula that I have typed in, the .0 has been
removed, shall I take it there is something wrong with my syntax.

Thanks for any help offerend
Phil