Macro to count Conditional Formatted Cells in the row

[Kyhosa]

Hi

I am looking for 2 things.
1. Macro that can count the number of yellow (255,255,0) cells within the row (G:L)
2. Then take that count and use it as the maximum number for conditional formatting-status bar in column F. Since each row will have a different number yellow cells, based on the "Title".


Attached is the Excel spreadsheet. I hope this makes sense.

Thank you in advance!