Hello All,
How could I replace Conditional Formatting with a VBA solution?
If any value within Worksheets("Remove_Reassign").Range("G42:O60") matches a value within table header "Merged" in table ThisWorkbook.Connections("Query - GroupAgnT1") (Table on sheet GroupAssignTable) then that cell is filled with vbGreen???
Conditional formatting looks great and is fast but doesn't work with the SelectionChange events that need to run when cells within the above range are clicked. If the cell ColorIndex is vbGreen (4) then Macro1; else if ColorIndex is 0 then Macro2.
Thanks for any help with this
How could I replace Conditional Formatting with a VBA solution?
If any value within Worksheets("Remove_Reassign").Range("G42:O60") matches a value within table header "Merged" in table ThisWorkbook.Connections("Query - GroupAgnT1") (Table on sheet GroupAssignTable) then that cell is filled with vbGreen???
Conditional formatting looks great and is fast but doesn't work with the SelectionChange events that need to run when cells within the above range are clicked. If the cell ColorIndex is vbGreen (4) then Macro1; else if ColorIndex is 0 then Macro2.
Thanks for any help with this