I have scoured the internet and have not found anything to simply count the number of cells in a row that have bee colored by CF. I can't count the number of different codes I have tried from YouTube and Google, and ChatGPT, and ..... I thank you in advance for your consideration.
First: I am old and do not speak or write code. It's all alien to me. Second, I don't want to run a macro to complete the task - automatic update. Third: cell X8 has the fill color I want the highlighted cells to have. Fourth: I use Office 365
Below is my simple little spreadsheet. You can see the cells highlighted in Orange. These are conditionally formatted to indicate a birdie (a golf thing).
What is the code that can do this?
Thank you so much for your assistance!
First: I am old and do not speak or write code. It's all alien to me. Second, I don't want to run a macro to complete the task - automatic update. Third: cell X8 has the fill color I want the highlighted cells to have. Fourth: I use Office 365
Below is my simple little spreadsheet. You can see the cells highlighted in Orange. These are conditionally formatted to indicate a birdie (a golf thing).
What is the code that can do this?
Thank you so much for your assistance!