Filter criteria in reference cells
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, |
Filter criteria in reference cells
Better to stay in the original thread.
Go Bucks!!! wrote: 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, -- Dave Peterson |
All times are GMT +1. The time now is 11:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com