I have two dates and the difference between the two dates in another column. But, I don't want anything to show in the result column if the later date is missing. So I have a formula =IF(J2="","",SUM(J2-F2)) - where J2 is the later date and F2 is the earlier date. Then I wanted to highlight the cells where the difference in the dates is greater than 42. So - I have put a conditional formatting on the results cell to highlight cells > 42. The problem I have is that this is also highlighting all the cells that do not have a value because there is no later date - How can I fix this so that only cells with a value > 42 are highlighted? Thank you.

Here is an example.

Attached Files

CF.xlsx (10.9 KB, 10 views)