Jan 09 2022 01:46 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.
Activate the Fill tab.
Click OK, then click OK again.
Jan 09 2022 02:34 PM