Forum Discussion
excel date color
I want to setup multiple cell to auto color as a date is getting closer. Can I set this up to do automatically when I turn on my computer?
Hi Kevin,
You may use conditional formatting with 3 rules, one for each color. Formula for the red color rule could be like
=($A$1-TODAY())<10
, other ones are similar. Combination of absolute/relative references and to which range to apply depends on how your data is structured.
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.
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.
Hi Kevin,
I guess there is some logic behind your cells linking, if so perhaps that could be possible using such logic. Could you provide small sample file to illustrate how it looks like?