counting based on conditional format

hi hope theres a way to do this.

i have a spreadsheet which is used to keep the training records for the company it counts no of staff and their skill levels for different parts of the job, when a person moves to a different branch the skill required changes and they have a set period of time to aquire the new skill.

when the time is up the colour of the old skill is changed to a red font by a conditional format based on the date.this is then counted by a calculation so the team know how many people are to be targeted for extra training.

the problem i have is the calculation will not count conditionally formated cells, so whenever i update the sheet i have to go to each cell with red text and change the font colour manually to red, this sounds really silly and is impossible to explain to anyone who does not understand conditional formatting. i e the people who will end up using the database

what im looking for is a way to count conditionally formatted cells based on the condition being met i.e. they are showing as red font.

can it be done and how?
or am i wasting my time looking for an answer to something excel wont do ?

already been there, if you read through about 3/4 way down the page there are a couple of constraints, the one that concerns me i've copied below

"The second shortcoming is that this technique at present does not cater for cells that are coloured due to conditional formatting"

the result being that this will do what i already have in use but not what i'm trying to achieve.

thanks for the link anyway, couple of things in there that may be useful in the future

this looks like what i need but i cant get it to work, i've copied the code in and set up a formula to call it but all i get is #value!. the formula im using is =sumbycfcolorindex(h11:h91,1). i've tried changing the last value as advised on the article but just get the same result. what am i doing wrong(PROBABLY SOMETHING SIMPLE)