I will start with a date; I need project out 180-days. I would like for the project date to stared out "Green", once my date get halfway I would like my project date to go to "Yellow" and when I'm within 10days of my project date change to "Red". And if possible I would like for this to happen automatically when I turn on my computer?
Thanks for your help. I got that worked out now. But there is one other thing that I would like to do. When the cells I have setup to change color I would like to link other cell to theses cells and have them change to the same color as the one I have already setup.