Filter criteria in reference cells

[Go Bucks!!!]

I was trying to do conditional formatting by filtering on the customer
(column E) and applying my conditional formating to those cells. It didnt
work. Can I do conditional formatting based matching the customer and
criteria?


My data is as follows:

E I
1 Toshiba 95%
2 Intel 92%
3 Samsung 89%

Performance Targets:
L M
1 Toshiba >=95%
2 Intel >=90%
3 Samsung >=90%

The conditional formating formulas are currently...

AND(I2<>"",I2>=0.95)
Condition is green

AND(I2<>"",I2<0.95)
Condition is red

Thanks,

 

[Go Bucks!!!]

Great, thank you.

I created a reference table with my criteria. This is how my formula ended
up...

=OR(AND(I2<>"",E2=$K$5,I2>=$O$5),AND(I2<>"",E2=$K$6,I2>=$O$6),AND(I2<>"",E2=$K$7,I2>=$O$7),AND(I2<>"",E2=$K$8,I2>=$O$8),AND(I2<>"",E2=$K$9,I2>=$O$9),AND(I2<>"",E2=$K$10,I2>=$O$10))

Where: I:I are the results, E:E is the customer and O:O are the criteria,
e.g. 95.

Works great!

 

[Dave Peterson]

Better to stay in the original thread.

I was trying to do conditional formatting by filtering on the customer
(column E) and applying my conditional formating to those cells. It didnt
work. Can I do conditional formatting based matching the customer and
criteria?

My data is as follows:

E I
1 Toshiba 95%
2 Intel 92%
3 Samsung 89%

Performance Targets:
L M
1 Toshiba >=95%
2 Intel >=90%
3 Samsung >=90%

The conditional formating formulas are currently...

AND(I2<>"",I2>=0.95)
Condition is green

AND(I2<>"",I2<0.95)
Condition is red

Thanks,