View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karine Karine is offline
external usenet poster
 
Posts: 20
Default jumping rowsand highlighting cells

The months that the checks are required I will collect from other sources.
WEEK 1 week
2 M T W T F S S
Equipment Name 31 1 2 3 4 5 6 etc...
ROBOT 1

Thats what the workbook likes like but it goes for 52 weeks with the same
set up. If The maint check for Robot 1 was on (Monday 31 and is checked every
three months) i would want to highlight i would want to skip 90 (cells/days)
over and highlight that day.
Hopefully that clears things up a little bit.
Thanks again.
Karine