11-17-2018 01:00 PM
11-17-2018 01:11 PM
11-17-2018 02:30 PM
You may use conditional formatting with 3 rules, one for each color. Formula for the red color rule could be like
, other ones are similar. Combination of absolute/relative references and to which range to apply depends on how your data is structured.
11-25-2018 03:49 PM
11-26-2018 02:50 AM
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?
by Awooten on October 28, 2019
by page8888 on September 19, 2019