Want columns A and B to be highlighted the same color if E through V contains that color.
Only colors that matter are yellow ColorIndex = 3 and red ColorIndex = 6.
If the row contains both colors red will be displayed.
If the row does not contain red or yellow then no change will be made to the A or B column.
To better explain:
In the attached spreadsheet A5 and B5 would be yellow because E5 is yellow.
In the attached spreadsheet A14 and B14 would be red because I14 is red.
Tried a few different things from the site here but was unable to find anything that I could get to work.
Tried using CF but could not figure out how to match ColorIndex.
Have no issue using CF if that is solution.
There is a Workbook_SheetSelectionChange that captures the color change and counts the cells.
Check Compliance button is redundant and will probably be removed.
There are is a dynamic range aRange that contains E5-V32.
If anything is unclear or there are any questions please let me know.