software

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 gt; .05 or both be gt;.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: www.excelforum.com/member.php...oamp;userid=29931
View this thread: www.excelforum.com/showthread...hreadid=523200quot;RalphSEquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; A little bit tricky this one, I have 2 columns of data that I want to
gt; apply a conditional formatting to. The conditions are that BOTH cells
gt; in any given row of the data be gt; .05 or both be gt;.04
gt;
gt; If both cells are greater than .04 each and also less than .05 each
gt; then I want to highlight both cells red. If both cells are greater
gt; than .05 then I want to highlight both cells blue. I can't seem to
gt; come up with the right formula for this. I'd appreciate some help
gt; PLEASE
gt;
gt;
gt;
gt;
gt; --
gt; RalphSE
gt; ------------------------------------------------------------------------
gt; RalphSE's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29931
gt; View this thread: www.excelforum.com/showthread...hreadid=523200
gt;

Ralph,

First instance, under cond. frmt.
=AND(A1gt;=0.04,B1gt;=0.04,A1lt;0.05,B1lt;0.05)=TRUE
Format for red.

Second instance
=AND(A1gt;0.05,B1gt;0.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: www.excelforum.com/member.php...oamp;userid=29931
View this thread: www.excelforum.com/showthread...hreadid=523200