Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 04-05-2023, 11:14 AM
kilroyscarnival kilroyscarnival is offline Conditiona Format, Icon Sets, Custom Windows 10 Conditiona Format, Icon Sets, Custom Office 2021
Expert
 
Join Date: May 2019
Posts: 363
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by Kwmck328 View Post
Still work on it with what you provided. I have created a new worksheet with the noted parameters that we were talking about. Perhaps this clean sheet is best... can you give me any suggestion for the 3 test conditions. I would then play around with them to see what works best. Thanks..
K...
Hi, it looks like you have the conditional formatting for the yellow (less than or equal to 118 days' difference between original date and today) and the red (greater than 126 days' difference between those dates.) Note that I used greater than or equal to 117 days, not 118, because I presumed your third category would cover 118 days in the green condition.

Where I appear to have messed up is I also have overlapping conditional formats on 126 days. The red formula should have > 126, not >= 126. So if it's exactly 126 days it still falls in the green, if I understood what you wanted.

All you really have to do is emulate the formula I had for the green condition, which in the case of this new file would be

Code:
=AND($R$23>=118,$R$23<=126)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Style Sets Stopped Working on Custom Template after Recent Microsoft Update CynthiaKPollard Word 6 12-20-2021 08:37 PM
RibbonX Editor - change Icon for custom AutoText Gallery Steve2081 Word 15 04-30-2021 07:58 PM
conditional formatting, icon sets gohn Excel 3 06-04-2018 12:15 PM
Conditiona Format, Icon Sets, Custom QuickAccess Toolbar Icon - How to make the icon display the state of the icon's action ElfegoBaca Word 1 08-13-2016 08:42 PM
Conditiona Format, Icon Sets, Custom VBA Word - Format ALL Tables - Apply Specific Formatting to Sets of Columns – Font, Border & Width jc491 Word VBA 10 11-04-2015 04:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 PM.


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