Jan 09 2022 01:46 PM
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?
Jan 09 2022 02:02 PM
Will the user enter a value in that cell, or is the value the result of a formula?
Jan 09 2022 02:14 PM
Jan 09 2022 02:24 PM
You might use conditional formatting:
Select the cell (or cells) that you want to format.
Set the fill color to green (this will be the default).
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop-down set to 'Cell Value'.
Select 'greater than or equal to' from the second drop-down.
Enter 400 in the box next to it.
Select Format...
Activate the Fill tab.
Select red.
Click OK, then click OK again.
Jan 09 2022 02:34 PM
Sep 14 2023 05:13 PM
@Hans Vogelaar Hello, How to change the value of the cell if the value is being inserted by the user in the cell?
Sep 15 2023 01:04 AM
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.