Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 15
Default Formula

Cant get my head around this, if a task hasn't been ticked for two weeks and
over for the corresponding weeks, I want the Task to flash up in red. So in
the exmple below Task2 would flash up red. It would go off red as soon as
the 1 is placed in a new week, so for task2 if 25 Dec was ticked then the
red would disappear.

December January
4 11 18 25 1 8 15 22 29
Task1 1 1 1 1
Task2 1
Task3 1 1 1
Task4 1 1 1 1