In a spread sheet I am working with I have two columns; names and positions. The first contains the name of an individual filling the position in the second column. If the first column is "NOT FILLED" I have already formatted its fill to be grey. I want to format the position associated with the at cell to be the same fill color.
Is conditional formatting the solutions and if so how would I do that?
Thanks in advance...