![]() |
#2
|
|||
|
|||
![]()
It's simple! Use rules you used for conditional formatting as filter conditions for average calculations.
The easies wayt will be to use (some) hidden column(s), where some numeric values are calculated depending on one specific conditional formatting rule, or on set of conditional formatting rules. And then you can use hidden column(s) to define conditional formatting rules too - like when value in hidden column is x1, then rule 1 is applied. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to highlight the cells using conditional formatting? | LearnerExcel | Excel | 1 | 01-01-2019 01:43 AM |
Conditional formating all cells in an array based on adjacent cells | deejay | Excel | 6 | 12-20-2016 12:00 PM |
Dynamic, Formatted Cells (Linked) | ShankedS | Excel | 1 | 08-11-2015 02:34 AM |
Header must toggle text & color + show count of conditionally formatted cells below | Franktoon | Excel | 3 | 02-18-2014 02:10 PM |
Odd behaviour in formatted cells | furface00 | Excel | 3 | 03-11-2011 08:02 AM |