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

"RalphSE" wrote in
message ...

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


Ralph,

First instance, under cond. frmt.
=AND(A1=0.04,B1=0.04,A1<0.05,B1<0.05)=TRUE
Format for red.

Second instance
=AND(A10.05,B10.05)=TRUE
Format for blue

Beege

THANKS SO MUCH BEEGE!!

didnt know about the and function, ezzzactly what i was looking for


:)


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