Forum Discussion
Setting a Cells Background Value
I'm hoping someone can help as I'm going insane trying to work it out. Ill try and explain the best I can. I want the Cells under Lots (the clear cells) to equal the value under column B & D. eg Lin...
It would be AMAZING if a formula exists to set the background color of a cell (or a foreground color) based on a cell having the text as a hex rgb value.
For instance if cell A1 has the value ="#FF0000" and a formula =SetBackgroundColor(A1) is in cell A2, the A2 cell suddenly has a red background color. Error would be set if the format of the A1 cell is not #000000.