Conditionally format one cell based on another cell being blank in Excel

[exceluser123abc]

I have two columns of cells, one with the Due Date and one with the Received Date of certain parts.
If the Received Date column is blank, I want to compare the Due Date to today's date and conditionally format the cell if the part is overdue (red) or if it is due within two weeks (yellow).
If the Received Date column is full, I want to skip over that cell.
How do I conditionally format in Excel to look like the example in the below link?
Example

Thank you in advance!

 

[Scott T]

Re: How do you conditionally format one cell based on another cell being blank in Excel?

For overdue

Select the cells you want to conditionally format.
In conditional formatting use the formula and select your formatting

=AND(A4<$B$1,B4="")

make this the first rule and check stop if true in the CF rules manager


same for yellow but use this formula and make it last in the rules manager

=AND(A4<$B$1+14,B4="")

 

[exceluser123abc]

Re: How do you conditionally format one cell based on another cell being blank in Excel?

Thank you so much! That works perfectly.