Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-30-2023, 11:03 AM
Kwmck328 Kwmck328 is offline Conditiona Format, Icon Sets, Custom Mac OS X Conditiona Format, Icon Sets, Custom Office for Mac 2011
Novice
Conditiona Format, Icon Sets, Custom
 
Join Date: Feb 2015
Posts: 23
Kwmck328 is on a distinguished road
Default Conditiona Format, Icon Sets, Custom

I admit I am lost with this one.
Cell R3 - "120" (days max)
Cell L5 - date "16 Dec 2022"
R19 = Conditional Format Cell result ?

Display: Green DOT >R3 Number
Yellow DOT >= L5-10 ( 120days - 10 days for Yellow DOT warning)
Grey Down Arrow when < formula ( ?? )


I would like to have the GREY down arrow show from 0 to 109 day, then the Yellow DOT from 110 to 119 days and Green DOT @120 days.

0 day to 109 days = Grey ARROW Down
110 days to 119 days = Yellow DOT
120 +5 days = Green DOT
Repeat with a 240 day cycle
Thanks ...
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 11:40 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