Jimmypop
Well-known Member
- Joined
- Sep 12, 2013
- Messages
- 753
- Office Version
- 365
- Platform
- Windows
Good day I have tried numerous examples but not working with my data set.
I have a named Range "Days_Overdue_Format". This range is made up of different sections in sheet and does not always follow each other e.g. =Questions!$O$6:$O$68,Questions!$O$73:$O$92 etc. (too long to post here)
I want to count the colored cells in Range and then return this value to a cell. e.g. there are for instance 25 red, 42 orange cells in range. The cells are colored using conditional formatting.
So result should look something like: (must also update if cell changes color)
Thank you.
I have a named Range "Days_Overdue_Format". This range is made up of different sections in sheet and does not always follow each other e.g. =Questions!$O$6:$O$68,Questions!$O$73:$O$92 etc. (too long to post here)
I want to count the colored cells in Range and then return this value to a cell. e.g. there are for instance 25 red, 42 orange cells in range. The cells are colored using conditional formatting.
So result should look something like: (must also update if cell changes color)
Green (Colored using CF - RGB(0,255,0) | 9 |
Orange (Colored using CF - RGB(255,192,0) | 42 |
Yellow (Colored using CF - RGB(255,255,0) | 18 |
Red (Colored using CF - RGB(255,0,0) | 25 |
Thank you.