Counting cells that are red in font colour

I Hope someone can help me here....

I have a pivot and in the column next to the pivot (for this example column AI) in cell AI5 i want it to calculate the number of celss betwen W5:AG5 where the font colour is red.

I have used conditional formatting to pick out the cells that font colour should be red based on a value.

I have looked over the internet for solutions and also tried testing a few functions and formulas myself but to no avail.

I have now come to a conclusion that code is needed to be able to do these calculations.

Would anyone have any idea how this can be done?

Dan

What is the condition that drives the conditional format? You can derive a count of those cells (using COUNTIF) with a similar condition in the formula.

Pete

Does this help?

Please Login or Register  to view this content.

I dont know why i was trying to complicate things!!

I used your idea Pete_UK, but used a sumif, as i need to sum the total of the value in the cells in the range if it is less than 25, this now works fine, and obvioucly there is no need for condityional formatting.

John, that does help yes thank you, and could be a handy code to have for future reference, as i tend to use conditional formatting based on cell colour and font,

Thank you both

Well you said you needed to:

calculate the number of celss betwen W5:AG5 where the font colour is red.

which I took to mean COUNT them, but it's the same approach if you need to SUM them.

Glad you got it working.

Pete