How to write: if c2>c3 and c4 ?

  • Thread starter Thread starter EduardoDon
  • Start date Start date
E

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
 
=AND(C2>C3,C2>C4)

or

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


that's all that is needed for conditional formatting

format>conditional formatting>formula is
 
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
 
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?
 
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
 
Not sure if I understand the problem, but try switching the order of the
conditions so that the more restrictive one appears first.
 
Back
Top