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.
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.
- Thanks so much! This will save me so much time!