bill351
Board Regular
- Joined
- Jan 19, 2009
- Messages
- 83
Hey guys I have a Training scheduling sheet with a range from D4 to H132 and what I am trying to do is highlight pending training dates.
What would be ideal is 30 day as red, 60 days as yellow and everything above 60 days as green. I have tried a simple =NOW()+30 however when trying for all 3 they override each other and I was given IF((TODAY()-A1)>30,TRUE,FALSE)however this didn't work across the whole sheet as well? We originally had a tracking sheet that did all this but it has been deleted a few years ago and cant be retrieved
Thanks from Oz
What would be ideal is 30 day as red, 60 days as yellow and everything above 60 days as green. I have tried a simple =NOW()+30 however when trying for all 3 they override each other and I was given IF((TODAY()-A1)>30,TRUE,FALSE)however this didn't work across the whole sheet as well? We originally had a tracking sheet that did all this but it has been deleted a few years ago and cant be retrieved
Thanks from Oz