Help with this macro would be much appreciated.
Select a cell within the range C2:D2000 and run a macro that colors the corresponding cell in column A.
For example: Select one cell C4 or D4 and run the macro, this would color cell A4 but if the selection was outside of the range C2:D2000, a msg box would open.
Bookmarks