Macro to count cells with conditional formatting in place

[dave1983]

Good Afternoon

I have the following code added to my workbook that allows a count to take place if someone manualy colours a cell (they do this to represent a late start), I have ammended this to automatically lookup the start time against what time they were meant to start and if they are late then I have conditional formating via a formula to colour the cell.

Please Login or Register  to view this content.

I guess because the user is not causing an event to take place the count element is not working, Is there a way to ammend the code to work for conditionaly formated cells.

I have this formula in place to call the code above:

Please Login or Register  to view this content.

[6StringJazzer]

The attribute ColorIndex is the base fill color set for the cell. It does not change if the fill color is changed by conditional formatting.

The only way I know how to do what you want (and I will say up front that there may be another way) is to use the same conditions in your code that are used by conditional formatting to change the fill color. You will have to extract the condition for the desired cell from the conditional formatting formulas, or hard code it.