Nov 17 2018 01:00 PM
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?
Nov 17 2018 01:11 PM
Nov 17 2018 02:30 PM
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.
Nov 25 2018 03:49 PM
Nov 26 2018 02:50 AM
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?