Forum Discussion
Change cell colour when a set value is reached
I want to change a cell colour when a certain value is approaching (say$400) from Green to Red, how do I go about it?
Will the user enter a value in that cell, or is the value the result of a formula?
HansVogelaar Hello, How to change the value of the cell if the value is being inserted by the user in the cell?
The conditional formatting should still work if the user enters the value.
You'd have a problem if they populate the cell by copying and pasting a cell from elsewhere.
