Menu
Ask a question Report

Conditional Formatting using dates/data in an adjacent cell [Closed]

- - Latest reply: TrowaD
Posts
2559
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 12, 2019
 - Oct 30, 2018 at 12:24 PM
Excel Ask a question Report
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 

1 reply

Report
Posts
2559
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 12, 2019
 370
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
Ask a question