Conditional Formatting using dates/data in an adjacent cell
Closed
CDP1524
-
Oct 29, 2018 at 12:48 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 30, 2018 at 12:24 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 30, 2018 at 12:24 PM
Hello,
I am creating a project status sheet where dates entered in an empty column (Column C) that are past the "planned start date" (column B, holds data) will turn red. I'm looking to use a formula as I have several rows of data.
Thank you!
I am creating a project status sheet where dates entered in an empty column (Column C) that are past the "planned start date" (column B, holds data) will turn red. I'm looking to use a formula as I have several rows of data.
Thank you!
Related:
- Conditional Formatting using dates/data in an adjacent cell
- Tmobile data check - Guide
- Based on the cell values in cells b77 ✓ - Excel Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Digital data transmission - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Oct 30, 2018 at 12:24 PM
Oct 30, 2018 at 12:24 PM
Hi CDP1524,
Try using this formula:
=$C2>$B2
Use the "applied to" box to choose the cells you want to format.
For example: =$C$2:$C$100
Best regards,
Trowa
Try using this formula:
=$C2>$B2
Use the "applied to" box to choose the cells you want to format.
For example: =$C$2:$C$100
Best regards,
Trowa