G
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,
(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,