Dec 14 2019 02:13 PM - edited Dec 26 2019 03:06 PM
I want to use something like:-
Copy "=INDEX(BY49:BZ54,(AZ58-AZ56+3),2)" & Paste into (CE58) using a VPA macro
Defined table Index into colored
Cell to Copy from
I have a table (row) containing golf scores. I have another table (row) containing the PAR values for each hole. I want to compare each score with the corresponding PAR value & Copy the Color of the golf score cell value (using a 3 x 6 color table for Pars 3/4/5) depending on whether the score is 1 under PAR (Yellow), 2 under PAR (Gold), 3 under PAR (Purple), 0 under PAR (Green) or 3 strokes over PAR (Red).
Is this possible using Excel Formulae with VPA?