View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hansonb4 hansonb4 is offline
external usenet poster
 
Posts: 2
Default FILL FUNCTION NEEDED

I am tracking 150 open issues, each one having the date the issue opened in
column E. I need to know when one of the open items reaches 45 days aging by
having that row moved to row 1 and the fill of each cell in that row
highlighted yellow. Any rows that have a date in column E that reaches an
aging of 90 days needs to have priority, inserted above the yellow rows and
be filled red. Please help