Copy & Paste cell containg Color fill using VPA

%3CLINGO-SUB%20id%3D%22lingo-sub-1066724%22%20slang%3D%22en-US%22%3ECopy%20%26amp%3B%20Paste%20cell%20containg%20Color%20fill%20using%20VPA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1066724%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20use%20something%20like%3A-%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ECopy%20%22%3DINDEX(%3CFONT%20color%3D%22%23ff0000%22%3EBY49%3ABZ54%3C%2FFONT%3E%2C(%3CFONT%20color%3D%22%230000ff%22%3EAZ58-AZ56%2B3)%2C2%3C%2FFONT%3E)%22%20%26amp%3B%20Paste%20into%20(CE58)%20using%20a%20VPA%20macro%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%20%3CFONT%20color%3D%22%23ff0000%22%3EDefined%20table%3C%2FFONT%3E%26nbsp%3B%20%3CFONT%20color%3D%22%230000ff%22%3EIndex%20into%20colored%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%3CFONT%20color%3D%22%230000ff%22%3ECell%20to%20Copy%20from%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20table%20(row)%20containing%20golf%20scores.%20I%20have%20another%20table%20(row)%20containing%20the%20PAR%20values%20for%20each%20hole.%20I%20want%20to%20compare%20each%20score%20with%20the%20corresponding%20PAR%20value%20%26amp%3B%20Copy%20the%20Color%20of%20the%20golf%20score%20cell%20value%20(using%20a%203%20x%206%20color%20table%20for%20Pars%203%2F4%2F5)%20depending%20on%20whether%20the%20score%20is%201%20under%20PAR%20(Yellow)%2C%202%20under%20PAR%20(Gold)%2C%203%20under%20PAR%20(Purple)%2C%200%20under%20PAR%20(Green)%20or%203%20strokes%20over%20PAR%20(Red).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%20using%20Excel%20Formulae%20with%20VPA%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1066724%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor

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?

0 Replies