Conditional Formatting Question

R

Rollin_Again

I want to use a formala to conditionally format cell E1 to highlight
with a green background if cell A4=C4 and Cell B4<D4

how can this be done?



Rollin
 
J

JulieD

Hi Rollin

select cell E1,
choose format / conditional formatting
choose
formula is
type
=AND(A4=C4,B4<D4)
click on the format button - set your format, click OK twice

hope this helps
Cheers
JulieD
 
R

Rollin_Again

Thanks Julie, I actually need to modify the conditional format.

Here is what I need.


IF cell A7 <= C7 AND either B7 < D7 or D7 - B7 > 0 THEN forma
green.


Thanks,
Rolli
 
D

Dave Peterson

How about:

=AND(A7<=C7,OR(B7<D7,D7>B7))

When I'm testing these kinds of thing, I'll use an extra cell and just put the
formula in there.

Then I can change the test data and see if the formula returns true/false. And
if it doesn't work correctly, I can modify that formula faster than going
through the Data|Validation dialog.

Then when it's perfect, I just copy it from the formula bar and paste (using
ctrl-v) into that formula box.
 
D

Dave Peterson

I may have seen a post by someone who noticed this before I did.

but maybe not--I ain't saying, er, admitting.

(Happy, Deb???)

hehehe
 
D

Debra Dalgleish

I'm sure it was just a coincidence, especially since you didn't copy the
absolute references. <g>

Dave said:
I may have seen a post by someone who noticed this before I did.

but maybe not--I ain't saying, er, admitting.

(Happy, Deb???)

hehehe


Dave said:
Hey:

B7<D7 and D7-B7>0 are the same check!

=AND(A7<=C7,B7<D7)
Click to expand...
Click to expand...
 
Top