I would like to get some help writing a VBA code that will pull the color of the cell next to a date and fill a cell in another spreadsheet with that color.
I have a vlookup that searches these dates and pulls the value from the cell, but don't know how to write it to pull color of adjacent cell. See it below.
=IFERROR(VLOOKUP(D2,'[MO Project tracker.xlsx]Alliance of SWMO PH2-3'!$C$12:$T$27,2,FALSE),0)
This formula picks the cell to the right of the date and pulls the dollar value from there. I would like to pull the color of the cell to the left and put it somewhere.
I have a vlookup that searches these dates and pulls the value from the cell, but don't know how to write it to pull color of adjacent cell. See it below.
=IFERROR(VLOOKUP(D2,'[MO Project tracker.xlsx]Alliance of SWMO PH2-3'!$C$12:$T$27,2,FALSE),0)
This formula picks the cell to the right of the date and pulls the dollar value from there. I would like to pull the color of the cell to the left and put it somewhere.