Noxqss38242
Board Regular
- Joined
- Sep 15, 2017
- Messages
- 223
- Office Version
- 2016
Have a cell range D7:AB36
Cells will randomly highlight based on another cell's entered data.
How can I auto sum each column's cells based on if that cell is highlighted with conditional formatting?
So essentially only sum the colored cells per column.
Thank you in advance!
Cells will randomly highlight based on another cell's entered data.
How can I auto sum each column's cells based on if that cell is highlighted with conditional formatting?
So essentially only sum the colored cells per column.
Thank you in advance!