Conditional formatting with variables

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
 
M

mikearelli

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple nested if and statement 2
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Conditional Formatting Amendment 2
Finding the right style field in VBA 0
Calculating Average, Count, Min & Max against a range of Values 0
Nested IF conditions 3
Word VBA - Want to test if Full Name is NOT Present in document 0
Sumproduct seems off... HELP PLEASE! 3

Top