Color changing cells after 60 minutes

[tjas9837]

ok maybe I did something wrong. it kind of worked. let me update my example a little bit better.

please note that the range is row 32 down to row 300. I need one of two things to happen automatically and continiously. 1: the optimal result: I would like the reference table (a1-d27) each row to change color after one hour of the most recent corresponding header has elasped i would like the reference row to turn red, and then if a new entry is made below row 31 for that header it resets. if that is not possible then I would like colomun f32-300 , each cell to turn red after 1 hour. note i am using military time and general formating.

[jeffreybrown]

We would love to help you with your query, but first, before we can proceed, please see Forum Rule #1 about proper thread titles and adjust accordingly...

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.