memoorefield
New Member
- Joined
- Jun 17, 2015
- Messages
- 14
I can't figure out how to count the number of cells that are highlighted in a conditionally formatted column in Excel 2013. I have read through and tried many of the VBA solutions on this site but none seem to work in my spreadsheet.
Here's a general overview of the spreadsheet - Column A is conditionally formatted to highlight cells with a number that falls outside of a range defined in column B. However there are about 18 different conditions. If I need the count of all the highlighted cells to show in cell A1000 how would I do this?
Here's a general overview of the spreadsheet - Column A is conditionally formatted to highlight cells with a number that falls outside of a range defined in column B. However there are about 18 different conditions. If I need the count of all the highlighted cells to show in cell A1000 how would I do this?