Nov 23 2022 08:30 AM
Hi - every help article I've found gives good directions for how to format cells based on a comparison of current cell value to adjacent cell value (i.e. equal or unequal, greater than or less than), but what I need to do is a little different:
I need the names in Column E below to be color-coded according to the value of the adjacent cell in Column F. For example, the name in cell E4 needs to be shaded red/pink because that person was rated "Red" in Column F. The name in cell E5 needs to be shaded blue because that person was rated "Blue" in Column F... etc. Is there any way to do this?
Nov 23 2022 09:05 AM
SolutionNov 23 2022 09:17 AM
Nov 23 2022 09:21 AM
Nov 23 2022 09:05 AM
SolutionHere's what the rules look like (Sample xlsx attached, too):