|
|
#1
02-09-2019, 04:35 AM
|
|||
|
|||
Average on conditional formatted cells
Hi all I need some help I've made some rules with conditional formatting on a spreadsheet Like when true - mark as bold or mark with a blue background. Now I would like to do some calculations based on those rules. For example, I need to calculate the average of all bolded cells (and only the bolded cells) Can it be done and how? 
|
|
|
Similar Threads
|
||||
| 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 |
Windows 10 
Office 2010
Threaded Mode