Conditional Formatting using dates/data in an adjacent cell

Closed

CDP1524 - 29 Oct 2018 à 12:48
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 30 Oct 2018 à 12:24

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!

Conditional Formatting using dates/data in an adjacent cell
Excel clear formatting - Guide
Tmobile data check - Guide
Conditional formatting excel dates - Guide
Conditional formatting based on another cell text - Excel Forum
Mint mobile data not working ✓ - Network Forum

1 response

Réponse 1 / 1

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
30 Oct 2018 à 12:24

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

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Hosted app data will not clear

Conditional Format Cells Based on Another Cell and Own Cell

Conditional Formatting - highlight overdue dates

Similar discussions

Subscribe To Our Newsletter!