Hello all,
I have the formula =MIN(S3:U3) in cell C3. I have cell S3 filled with YELLOW, T3 filled with GREEN, U3 filled with RED.
My question is how do I get the color of S3, T3 or U3 to follow into C3 based on which ever one has the minimum number? The same cell may not have the min number every time.
I've tried putting in simple formulas such as =S$3$ and format the color in conditonal formatting but that doesn't work. Also tried one such as =IF(S3<T3,U3) and format the color in conditional formatting, this doesn't work either.
Any suggestions? Thanks in advance.
Bookmarks