View Single Post
 
Old 04-01-2023, 07:54 AM
Kwmck328 Kwmck328 is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: Feb 2015
Posts: 23
Kwmck328 is on a distinguished road
Default

Thank you for the reply.. I have since viewed a number of youtube video's on Condition Formatting, Icon Sets etc.. Intention is to play around with this until I get it working.
Current version is now as follows...
Cell M2 contains a input date "16 jan 2022"
Cell R3 =M2
Cell R19 =R3+120 "15 Apr 2023"
C/F: Icon Set, Custom - G,Y,R
G >= | =R3+120
Y >= | =TODAY()
R default
I would like to see Green between 118:125 days
Yellow or DOWN Arrow for anything between 1:117
It's a plan for now...any further suggestions welcome.
Thanks
Reply With Quote