I am needing a way to, formula or macro, to count the number of cells in a row that are conditionally formatted. I am novice with VBA and from my searching it looks like all solutions are based on VBA. I've been trying to get them to work with my data but haven't had any luck. So I'm hoping a specific thread with an example of my data might yield a more specific code. Below is an example of what I'm working with:

Column A Column B-P
Locations Values

Each column B-P is conditionally formatted so the top or bottom 5 values have Light Red Fill and Dark Red Text. I am wanting to have another column, R, that shows how many cells are conditionally formatted in each Location row. For example, Location 1 (row 2) might have 3 cells in it's row that are in the top 5, thus conditionally formatted to Light Red Fill and Dark Red Text. I am looking for a way to have cell R2 look in B2:P2 and return the number of cells that are conditionally formatted, 3.

Any help would be greatly appreciated. Please let me know if this is not clear enough. Thanks!