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