Forum Discussion
How to change cells colours when an expiry date is coming to an end
belly101 Is this the one that you are looking for? Manual insert /change date will auto change the color.
You can use Conditional Formatting for that. See for example Conditional Formatting
If you would like more help, please provide some details about your setup.
Hans
I have a similar question, and the answer may assist.
I would like to change the colour of a cell, depending on the context of another cell.
Possibly and if statement -
if(A1>100, set Cell A1 fillcolor to green, set Cell A1 Fillcolor to Red)
Now, I have used 'set Cell Fillcolor to ... and this is what I would like clarified, what should that be?
Thanks in anticipation
You write
I would like to change the colour of a cell, depending on the context of another cell.
but you then mention only cell A1...
I also have a similar question. See if this helps us all get an answer.
In cell A1, if the number is equal to or greater then 1, then I would like cell A2 to turn orange.
Could you help with this example?
Select cell A2.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=A1>=1
Click Format...
Activate the fill tab.
Select orange.
Click OK, then click OK again.