Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Non-Blank Cells in Column If a Reference Criteria Met. | Excel Discussion (Misc queries) | |||
How to create filter using criteria from other cells. | Excel Worksheet Functions | |||
Advanced Filter for multiple criteria, including blank cells | Excel Worksheet Functions | |||
How to Filter cells and save the file with certain criteria? | New Users to Excel | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |