Are you sure they all have exactly the same value, that there is not some
small decimal portion on one or two that is not showing but which means the
value is above 95 (even though not 96)?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mhutch71" wrote in message
...
I have a worksheet that has conditional formatting set for an grade that
is
below 95 to turn red. The total worksheet has 160 entries and the
formatting
works on most of the cells except 4 vells show a grade of 95 and its in
red.
There are several other cells that are at 95 and are not red. I did a
paste
special across the worksheet, I have also tried to change the cell itself
and
I still get the same problem. Any way to fix this?