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,