I know that it’s quite straight forward to change a cell background color when a certain value is entered into a cell by using conditional formatting. Is there any way doing it the other way around and have a certain value displayed when a cell color is changed?
For example, if I have a range of cells A2:J100 containing no values with no background color, if the cell color in any of the cells is then changed to red, could a value of 100 be automatically displayed in that cell? Then if the cell color is changed to blue a value of 50 is displayed, if changed to green a value of 30 is displayed.
I only need three different colors, I don’t believe this can be achieved with conditional formatting and I’m not aware of any formula/function to do this but please correct me if I am wrong. Could it be achieved with a bit of VBA code?
For example, if I have a range of cells A2:J100 containing no values with no background color, if the cell color in any of the cells is then changed to red, could a value of 100 be automatically displayed in that cell? Then if the cell color is changed to blue a value of 50 is displayed, if changed to green a value of 30 is displayed.
I only need three different colors, I don’t believe this can be achieved with conditional formatting and I’m not aware of any formula/function to do this but please correct me if I am wrong. Could it be achieved with a bit of VBA code?