View Single Post
 
Old 12-09-2016, 01:24 PM
Gillian623 Gillian623 is offline Windows 10 Office 2016
Novice
 
Join Date: Dec 2016
Posts: 1
Gillian623 is on a distinguished road
Default Conditional Formatting for Cells Containing Formula

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.
Reply With Quote