After more testing, actually anything that is + current is still
highlighted.

i'm not too sure what is going wrong.

=OR(Current-F30<26, F30Current+26)

Anything less than current - 26 is not highlighted, which is correct

but everything above current is highlighted.

As small error that i am sure is easily correct, i am just ashamed to
say that my currently abilities make the answer illegible to me!

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=505456