I have created a conditional format that highlights a series of cells red when 2 dates are 14 days apart. =OR(($H$22-$I$22+1)>14,($I$22-$H$22+1)>14)
However as is now the formula is making all of the empty cells red. I'm trying to prevent this with condition 2. But I dunno what that would be. I want the empty cells, f12:i50 left alone unless there are dates in the h and i columns that are 14 days apart.
condition 1 = make cell f 12:I12 red if h12 and i12 are 14 days apart (example)
condition 2= ignore condition 1 if h column has no date (i column will always have todays date, h column is inputed by user).
Bookmarks