How would I take the Values of A1 - A6 and compare them to the Values in Columns B1-F6 and any values that match change the background color to limegreen of only those matching cells?
Thanks in advance -Brian-
How would I take the Values of A1 - A6 and compare them to the Values in Columns B1-F6 and any values that match change the background color to limegreen of only those matching cells?
Thanks in advance -Brian-
Hello, @bfpa40. Go to Format -> Styles -> New Style...
and create style with your preferred name, lets call it LimeStyle
Then go to Format -> Styles -> Manage Style
, right click on LimeStyle
and click Modify. Select Font Effects
tab and choose the font and other styling effects you want. Then select A1:A6
range, go to Format -> Conditional Formatting - > Condition...
and under Condition 1 select Formula is
, copy this formula in the text box SUMPRODUCT($B$1:$F$6;A1=$B$1:$F$6)
and under Apply Style
select LimeStyle
and click Ok.
I think the original question was rather about the value in column A matches any of the values in the same row of columns B to F, so the formula should be SUMPRODUCT(A1=B1:F1)>0
[I missed the 2D range earlier so deleted the previous comment]
Deleted mine as well. Yes, if the question is about matching value in the same row, SUMPRODUCT(A1=B1:F1)>0
is correct choice. I thought that @bfpa40 needs to match values in A1:A6
in the whole range. Read the question several times - still not sure what is the correct option. Anyway, TS now has two options to chose from