#1
|
|||
|
|||
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 ... |
|
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 |
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 |
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 |