| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Banding with Conditional Formatting with Multiple Conditions
I can set up banding using Conditional Formatting fust fine. The problem I
am having is that there are other conditions I need to have happen at the same time. For example, when cell F69 is greater than cell D72, I need it to be BOLD and ITALICIZED. When I use the banding formula in Conditional Formatting as the first Condition, it overrides the other conditions, so the cell is shaded, but not BOLD and ITALICIZED. If I make it the last Condition, the BOLD and ITALICIZED condition overrides the banding Condition. Does anyone know if there is a way to get around this problem? A lengthy formula, perhaps, to put into Conditional Formatting that will perform both functions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| Conditional Formatting Blank =white.. but 4 conditions | Excel Worksheet Functions | |||
| Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
| How do I use conditional formatting for multiple rows? | Excel Worksheet Functions | |||
Threaded Mode
