Forum Discussion
Paskylou
Sep 11, 2023Copper Contributor
colour changing cells
Good afternoon I have a spreadsheet which is used to manually input data including a date a customer is coming in to pick up an order. (That date is in cell B3) The Cell in G3 is going to be ...
HansVogelaar
Sep 11, 2023MVP
Excel does not provide color scale conditional formatting for a single cell.
You can create a set of rules, for example:
Select G3.
Set its fill color yo yellow. This will be the default.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=B3<=TODAY()+10
Click Format...
Activate the Fill tab.
Select orange as highlight color.
Click OK, then click OK again.
Repeat these steps but with the formula
=B3<=TODAY()+5
and red as fill color.
Repeat them again with the formula
=B3<=TODAY()+1
and dark red.
Finally, repeat them with the formula
=G3<>""
and green.
- PaskylouSep 11, 2023Copper ContributorThat makes sense thank you!