Need formula for Conditional Formatting

[Jon_Hurtado]

I am in need of a formula for conditional formatting that can fill in a cell in column U or N when there is no date and the corresponding date in M or N has past.  

I need a formula for conditional formatting that can identify cells in columns U or V (without dates in them) that are overdue as specified in Columns M or N.  

[#2]

@Jon_Hurtado 

Select U4:V1000 (or however far down the data go). I will assume that U4 is the active cell within the selection.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula

=AND(U4="",M4<TODAY())

Click Format...

Activate the Fill tab.

Select a highlight color.

Click OK, then click OK again.

[#3]

@Hans Vogelaar 

Thanks for responding, but that did not work.

[#4 · Accepted solution]

@Jon_Hurtado 

How about

=AND(U4="-",M4<TODAY())

[#5]

@Hans Vogelaar

Perfect!  Many thanks.