Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

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 10:42 AM.


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