Conditional Formatting using dates/data in an adjacent cell

Closed
CDP1524 - Oct 29, 2018 at 12:48 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 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!

1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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
0