K
Ken
OK ... I am trapped ... I have items I need to work on 1,
2, 4 & 12 Times a year. I setup formulas to calculate the
dates (format = Date mm/dd/yy) & I created a Calendar with
formulas & setup 16 months ... Nov-Dec 02, Jan-Dec 03, Jan-
Feb 04 ... Now I am trying to use conditional formatting
in the Calendar section of spread sheet to target each
date generated by the formulas.
IE:
If 12 checks & 1st date = 1/15 ... All months would
reflect a high-lited day approx 31 days from this date.
If 4 checks & 1st date = 1/15 ... only those dates approx
92 days from this date would be high-lited.
If 2 checks & 1st date = 1/15 ... only those dates approx
183 days from this date would be high-lited.
And yes ... if only 1 check ... that's the date. (Note
that 1st date may occur anywhere in the year???)
I think this can be done, but my head is swimming ...
I might be able to write formulas in separate cells to
show all dates (maybe?) ... but am clueless as to how I
might be able to make the Calendar high-lite as indicated
above ...
Many thanks to whoever helps bring this home & to all
those that support this board ... Kha
2, 4 & 12 Times a year. I setup formulas to calculate the
dates (format = Date mm/dd/yy) & I created a Calendar with
formulas & setup 16 months ... Nov-Dec 02, Jan-Dec 03, Jan-
Feb 04 ... Now I am trying to use conditional formatting
in the Calendar section of spread sheet to target each
date generated by the formulas.
IE:
If 12 checks & 1st date = 1/15 ... All months would
reflect a high-lited day approx 31 days from this date.
If 4 checks & 1st date = 1/15 ... only those dates approx
92 days from this date would be high-lited.
If 2 checks & 1st date = 1/15 ... only those dates approx
183 days from this date would be high-lited.
And yes ... if only 1 check ... that's the date. (Note
that 1st date may occur anywhere in the year???)
I think this can be done, but my head is swimming ...
I might be able to write formulas in separate cells to
show all dates (maybe?) ... but am clueless as to how I
might be able to make the Calendar high-lite as indicated
above ...
Many thanks to whoever helps bring this home & to all
those that support this board ... Kha