We "stack" uniform spreadsheets (one below the previous) into a Master spreadsheet, but the column colors from the various spreadsheets vary. The columns run G:EL, and the range within each column is Row 4 : Row 627.
We trying to find code like:
=IF((G3="Discount"),change[G4:G627].Interior.ColorIndex=22, IF((G3="Min Chrg"),change[G4:G627].Interior.ColorIndex=30, "") .
Row 3 has the two column labels, that alternate for each column. But it needs to be applicable to columns G through EL.
Any insight or suggestions would be greatly appreciated.