#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Here is an example.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need conditional formatting formula | namedujour | Excel | 1 | 05-27-2016 08:58 AM |
Conditional Formatting Formula | teza2k06 | Excel | 1 | 08-22-2014 02:49 AM |
Formula/Conditional Formatting | teza2k06 | Excel | 1 | 04-15-2014 06:49 PM |
Excel Formula - Conditional replacement of cells | mag | Excel | 0 | 10-27-2012 08:30 PM |
conditional formatting formula | NEHicks503 | Excel | 1 | 11-30-2011 09:01 AM |