Forum Discussion
JasonPE509
Aug 07, 2023Copper Contributor
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...
- Aug 07, 2023
You may apply conditional formatting rule with formula
=COUNTIF($A$2:$D$20, $G2)to $G2:$G50 or so range
SergeiBaklan
Aug 07, 2023Diamond Contributor
You may apply conditional formatting rule with formula
=COUNTIF($A$2:$D$20, $G2)
to $G2:$G50 or so range
- JasonPE509Aug 07, 2023Copper ContributorThat's exactly what I needed. Thank you so much!
- SergeiBaklanAug 08, 2023Diamond Contributor
JasonPE509 , you are welcome