Keebler
Board Regular
- Joined
- Dec 1, 2021
- Messages
- 172
- Office Version
- 2021
- Platform
- Windows
I have several thousand cells with hex codes (as well as their RGB counterparts).
I need to have a formula that can look at a cell, pull the hex or RGB code and fill the cell with that color. based solely on the hex or rgb code. (A VBA code would be okay as long as it can move from column to column and row to row and put the hex or rgb code in an adjacent cell.
for example
the merged cell on the left is where i need the color displayed
note: when I say several thousand, I literally mean over 8 thousand different hex codes and their RGB compatriots.
I need to have a formula that can look at a cell, pull the hex or RGB code and fill the cell with that color. based solely on the hex or rgb code. (A VBA code would be okay as long as it can move from column to column and row to row and put the hex or rgb code in an adjacent cell.
for example
the merged cell on the left is where i need the color displayed
note: when I say several thousand, I literally mean over 8 thousand different hex codes and their RGB compatriots.