Count Cells with Conditional Formatting

[stephenclarke111111111]

Hi,

I'm trying to count cells that have Conditional Formatting, when looking at cell colour it doesn't recognise it's a red fill etc or a bold font.

See below , by Row and column i just need a total count of the Red cells.

Thanks.

 

[Fluff]

How about

=MIN(L3,COUNTIFS(P3:AO3,0))

 

[stephenclarke111111111]

How about

=MIN(L3,COUNTIFS(P3:AO3,0))

Works perfectly, thank you again.

 

[Fluff]

You're welcome & thanks for the feedback.