Conditional Formatting using dates/data in an adjacent cell

- - Latest reply: TrowaD
Posts
2435
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 4, 2018
- 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!
See more 

Your reply

1 reply

Posts
2435
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 4, 2018
0
Thank you
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
Respond to TrowaD