Thread: 90 day tracking
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
grizzly6969 grizzly6969 is offline
external usenet poster
 
Posts: 79
Default 90 day tracking

I have a spred sheet with a calendar from A12 to W87 =Jan 1 to Dec. 31
If john doe is absent I put an "A" in that date in the calendar
is it possible to have on sheet 2 lets say A2 turn red if there are 3 "A's "
in a 90 day period at any time through out the year
--
grizz