Forum Discussion
How do I make excel change the colour of a cell depending on a different cells date?
- Nov 21, 2022
Let's say you want to highlight a row if column F contains "Closed".
Use the formula
=$F2="Closed"
If you want something different, please provide more detailed information.
Hello,
column E does not have dates. Column F does, and so does column H. In the following I assume you want to use the date in column F. Change the formula to use H if you want to.
- Select cell A2
- click Conditional Formatting on the Home ribbon
- click New Rule
- click Use a formula to determine which cells to format
- click into the formula box and enter the formula
=$F2<Today() - click the Format button and select a red color
- close all dialogs
Repeat the steps and use the formula
=$F2=Today()
and select a yellow fill and red border.
Next, select cell A2 again, click the Format Painter in the home ribbon, then select all other cells below cell A2.
Does that help?
- leaguerjesOct 21, 2021Copper Contributor
Do you happen to know how to change the cell colour based on an other cell colour?
IE we have a shipping sheet with user name, address, contact number, items in box, box size, tracking number etc and the tracking number cell column is highlighted a colour based on its delivery (we change it to green once delivered) but we'd like the first cell in the row (or whole row) to also change green showing that whole line is complete.
I cannot find anything to support this
- rajtangSep 06, 2022Copper Contributor
i would like to be able to move the conditions to different cells.
basically id like to condition all the cells based on their own respective value without having to cell by cell
- tmcmahon71Nov 21, 2022Copper Contributor
How can I make this formula work using specific words instead of a date?IngeborgHawighorst
- HansVogelaarNov 21, 2022MVP
Let's say you want to highlight a row if column F contains "Closed".
Use the formula
=$F2="Closed"
If you want something different, please provide more detailed information.
- tmcmahon71Nov 22, 2022Copper ContributorYES! That is exactly what I was looking to do. Many many thanks Hans. I so appreciate your help.