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

[Lennox2525]

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.

Thank you for any help 🙂

[#2 · Accepted 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.

[#3]

Excellent - Thank you so much! 🙂