Counting Red Text Colour, When Applied by Conditional Formatting

Hello,

I have a spreadsheet that is used for testing equipment. In the G column it has a list of the expiry dates for the equipment to be tested.

I've used Conditional Formatting to change the font to Orange (when it will expire in 30 days or less) and Red (when a service is overdue.)

This are the conditional formatting formulas:

=NOW()+30

&

=NOW()

What I want to do is to count all of the items that have turned red. So I can see how many will need to be tested. This is going to be a big spreadsheet so I can't just count manually and risk missing things out.

Is there anyway of achieving this, preferrably without VBA?

My sample spreadsheet wont attach for some reason so will try again later!

Any help would be amazing!