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?
|