How to write: if c2>c3 and c4 ?

[EduardoDon]

HOW TO WRITE: IF C2>C3 AND C4

I wish to set
if C2 >C3 and C4 ,
then the background will change in color.

I dont know how to set the formula correctly,
while the latter is known to me.

Please help.
Thanks in advance.

Eduardo D

 

[Peo Sjoblom]

=AND(C2>C3,C2>C4)

or

=(C2>C3)*(C2>C4)


that's all that is needed for conditional formatting

format>conditional formatting>formula is

 

[Vasant Nanavati]

=AND(C2>C3,C2>C4)

I assume you want this for a conditional formatting formula.

 

[EduardoDon]

Dear Vasant,

Yes, I need it in conditional formatting formula.

But it doesnot work ?

WIll it be possible that " = IF ...AND..." be needed ?
What will be the correct expression , then ?

Looking to erceiving your instruction.

Eduardo

 

[Vasant Nanavati]

No, it should work exactly as written. Are you using the Formula Is dropdown
and did you actually set the formatting in the Conditional Formatting
dialog?

 

[EduardoDon]

Dear Vasant,


Yes it works, thank you.

EduardoD.

 

[EduardoDon]

Dear Vasant,

for:

if c2> c3 and c4
=AND(c2>c3,c2>c4) works perfect

but when:

condition i)
b4<b3 set to color"x"

condition ii)
if b4<b3 and b2
=AND(b4<b3,b4<b2) intended to be in color "y"

wont work, only color "x" shown ?


What should the the correct formula for the latter, then ??
Eager to receive an instruction.

Thanks in advance.


EduardoD

 

[Vasant Nanavati]

Not sure if I understand the problem, but try switching the order of the
conditions so that the more restrictive one appears first.

 

[EduardoDon]

Dear Vasant,

Ok, I'll try.

Thanks after all.

EduardoD