Forum Discussion
Daniel Cook
Aug 24, 2017Copper Contributor
How do I make excel change the colour of a cell depending on a different cells date?
Hi, How do I make excel change the colour of a cell depending on a different cells date? Turn A2 red if - E2 cell is smaller than todays date Turn A2 yellow with red outline if - E2 ce...
- 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.
Aug 25, 2017
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?
tmcmahon71
Nov 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.
- Ray_Z316Apr 19, 2024Copper Contributor
What if the same conditional format can be based on two differing texts in a single cell, such as =$F2="Closed" as well as "Closed-Ext". I'm not sure how to combine that in one conditional formula...
- HansVogelaarApr 19, 2024MVP
- kylee326Mar 13, 2024Copper Contributor
HansVogelaar what if I need a cell to change to be white if the adjacent cell is left blank I tried =D3=“BLANK” but that didn’t do the trick
- HansVogelaarMar 13, 2024MVP
- TanjaC74Mar 01, 2024Copper ContributorI have two sheets that are connected with formulas,when I change data in sheet 1 it changes in sheet 2.I want to ask what do I have to do,when I change data in sheet 1 to appear in another colour in sheet 2.
- HansVogelaarMar 01, 2024MVP
You can use conditional formatting referring to the values of the cells on Sheet2, just like when you enter the data there directly.