conditional formatting not working in every cell

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?

Is it possible that your CF refers to the cell above or below the actual cell?

i.e conditional formatting in B2 looks in B1 or B3

Something to look into.

Regards
JG

Is it possible that this is due to rounding?
Try changing the condition so that any grade that is below a 94.5 turns red.

"mhutch71" wrote:

> 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?

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" <mhutch71@discussions.microsoft.com> wrote in message
news:9CE38BE8-70BB-46D4-A92D-90B51718AB77@microsoft.com...
> 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?