Hi,

A little bit tricky this one, I have 2 columns of data that I want to
apply a conditional formatting to. The conditions are that BOTH cells
in any given row of the data be .05 or both be .04

If both cells are greater than .04 each and also less than .05 each
then I want to highlight both cells red. If both cells are greater
than .05 then I want to highlight both cells blue. I can't seem to
come up with the right formula for this. I'd appreciate some help
PLEASE

:)


--
RalphSE
------------------------------------------------------------------------
RalphSE's Profile: http://www.excelforum.com/member.php...o&userid=29931
View this thread: http://www.excelforum.com/showthread...hreadid=523200