Oct 20 2021 08:40 AM - edited Oct 20 2021 08:45 AM
I am trying to get numbers in E3-E5 that correspond to the number of cells from column G, F, and A respectively that are conditionally formatted to the background colors of E3-E5. I have tried several VBA options I came across on other sites and I can't seem to tailor them to both work for my data set and automatically update as the conditional formatting changes the background color.
Edit: Also assume I know nothing about VBA if that is the solution as I will not be able to understand looking at the code what data goes where when I execute the function
Oct 20 2021 09:18 AM
SolutionInstead of looking at the conditional formatting colors, look at the conditions themselves. No VBA needed. See the attached version.
Oct 20 2021 01:35 PM
Oct 20 2021 02:16 PM
You'll have to check the exact rules, and change the formulas accordingly.
Oct 20 2021 02:56 PM
Oct 20 2021 09:18 AM
SolutionInstead of looking at the conditional formatting colors, look at the conditions themselves. No VBA needed. See the attached version.