Sep 30 2020 03:02 PM
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.
Sep 30 2020 03:13 PM
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.
Oct 01 2020 06:45 AM
Oct 01 2020 08:04 AM
SolutionOct 01 2020 08:58 AM
Oct 01 2020 08:04 AM
Solution