Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

How to Conditionally Format a date cell based on any date being entered in another cell (same row)

Copper Contributor

Please can someone help ?

 

I would like to conditionally format Cells in Column B, based on a date being entered in Column C of the same row.

When a deadline date is first entered in Column B, it will turn red. It will turn green when a date is entered in Column C. 

I.e - B2 =  Red as no date entered in C2.

     - B13 - Green as date entered in C13.

Lennox2525_0-1707830180289.png

Thank you for any help :)

2 Replies
best response confirmed by Lennox2525 (Copper Contributor)
Solution

@Lennox2525 

Select the cells in the data range of the Deadline Date column, from  B2 down.

B2 should be the active cell in the selection.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula

=AND($B2<>"", $C2="")

Click Format...
Activate the Fill tab.
Select red as highlight color.
Click OK, then click OK again.

 

Repeat these steps, but with the formula

=$C2<>""

and green as fill color.

1 best response

Accepted Solutions
best response confirmed by Lennox2525 (Copper Contributor)
Solution

@Lennox2525 

Select the cells in the data range of the Deadline Date column, from  B2 down.

B2 should be the active cell in the selection.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula

=AND($B2<>"", $C2="")

Click Format...
Activate the Fill tab.
Select red as highlight color.
Click OK, then click OK again.

 

Repeat these steps, but with the formula

=$C2<>""

and green as fill color.

View solution in original post