Another Conditional Formating Question

R

RalphSE

Hi,

A little bit tricky this one, I have 2 columns of data that I want t
apply a conditional formatting to. The conditions are that BOTH cell
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 eac
then I want to highlight both cells red. If both cells are greate
than .05 then I want to highlight both cells blue. I can't seem t
come up with the right formula for this. I'd appreciate some hel
PLEASE

:
 
B

Beege

RalphSE said:
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

:)
Click to expand...

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(A1>0.05,B1>0.05)=TRUE
Format for blue

Beege
 
R

RalphSE

THANKS SO MUCH BEEGE!!

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


:
 
Top