Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2016, 01:24 PM
Gillian623 Gillian623 is offline Conditional Formatting for Cells Containing Formula Windows 10 Conditional Formatting for Cells Containing Formula Office 2016
Novice
Conditional Formatting for Cells Containing Formula
 
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
  #2  
Old 12-09-2016, 11:03 PM
xor xor is offline Conditional Formatting for Cells Containing Formula Windows 10 Conditional Formatting for Cells Containing Formula Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Here is an example.
Attached Files
File Type: xlsx CF.xlsx (10.9 KB, 8 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting for Cells Containing Formula Need conditional formatting formula namedujour Excel 1 05-27-2016 08:58 AM
Conditional Formatting for Cells Containing Formula Conditional Formatting Formula teza2k06 Excel 1 08-22-2014 02:49 AM
Conditional Formatting for Cells Containing Formula 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 for Cells Containing Formula conditional formatting formula NEHicks503 Excel 1 11-30-2011 09:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft