Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting Based on cell A text with conditions in Cell B
I am running a large pivot chart and each topic can have 5 sub
categories. Each of the 5 categories has a different threshold that I want to conditionally format. So row A has Bob, Row B has Break, Lunch, meeting; Row C has time 15, 30, 60 minutes. I need to set the condition for Break as over 15 is red, lunch over 30 is red and meeting is over 60 is red. I have read around a bit and haven't found a solution was wondering if it had been encountered before. Thanks, M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting one cell based on content of another cell | Excel Discussion (Misc queries) | |||
Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) | |||
Conditional formatting based on another cell | Excel Discussion (Misc queries) | |||
Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) |