Conditional formatting with variables

  • Thread starter Thread starter ScoobyDoo
  • Start date Start date
S

ScoobyDoo

Hi I have 2 columns of symbols with 8 variations as follows

Col 1 Col 2
= <
= =
= >
< <
< =
=
Click to expand...

and I wish to output a different message for each scinario ie if C1 = "=" &
C2 = "<" then output "No Change"

Thanks
 
In column 3 use this formula:
=IF(A1="=",IF(B1="<","Var1",IF(B1="=","Var2",IF(B1=">","Var3"))),
IF(A1="<",IF(B1="<","Var4",IF(B1="=","Var5",IF(B1=">","Var6"))),
IF(A1=">",IF(B1="<","Var7",IF(B1="=","Var8",IF(B1=">","Var9"))))))

Very clumsy, but it works.
 
Back
Top