View Single Post
 
Old 02-09-2019, 04:35 AM
nadavmaroko nadavmaroko is offline Windows 10 Office 2010
Novice
 
Join Date: Feb 2019
Posts: 2
nadavmaroko is on a distinguished road
Default 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?
Reply With Quote