How to count conditionally formatted font (red) cells and cell colour

[Nampara]

Thanks sktneer and kev_ who solved the first part of my problem now here is the second part -


I want to be able count the number of people who have No FTE (0.0) by campus colour where "Person? (0.0)" is conditionally formatted to red (RBG 255,0,0) - unfortunately I can't tell the spreadsheet to count 0.0 in the FTE column as the formula I have used returns 0.0 for job titles.

Sample spreadsheet attached.

Thanks

[xladept]

Well, it worked on your sample:

Please Login or Register  to view this content.

[Nampara]

Hi

Thanks for your reply unfortunately I can't get it to work in my sample spreadsheet. Could you reupload my sample with your solution.

Thanks

[xladept]

Here you go:

[Nampara]

thanks unfortunately I can't get it to work.

[xladept]

It's pretty quick - have you deleted G10:G15 and run it??

[Nampara]

Hi

Thanks for this it now works - just a quick query - the original spreadsheet I am working with has at least 5 columns that I need to count - will this allow me to count more than one column

[xladept]

In the code Cells(r,5) the 5 is for column "E" -the fifth letter.

For different columns you'd need different indices

You're welcome and thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.