Forum Discussion
Solved
Filling cell based off of specific name in area.
Hello, I am managing crews for a company. I am looking for a formula. I have a list of employees in row"G". I am assigning each employee to a crew "A2:D20". When I assign them to a crew"A2:D2...
You may apply conditional formatting rule with formula
=COUNTIF($A$2:$D$20, $G2)to $G2:$G50 or so range
That's exactly what I needed. Thank you so much!
JasonPE509 , you are welcome