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...
Perhaps you may illustrate in your file what is desired result since it's not clear what is required, at least for me. For example
"I then want to be able to color a cell or enter a number between 1-350 (preferably enter a number but color if easier)" - which cell, what is the logic to use this or that color / number?
"and it equal the value from column B & D not the number in the cell." - 'value' assumes one cell, not columns. What exactly shall be taken from B & D ? Do not number in which cell?