Forum Discussion
Solved
Conditional Formatting
I created a mock wire list that is similar to what I have at work. The technicians usually highlight a physical copy when the wires are installed. Here's an example. So the table shows ...
Millertime9460 Here is one option (it assumes you have excel 365). Custom formula in conditional formatting:
=($K6="LS")+($K6<>"RS")*(TRIM(CONCAT(FILTER($K$6:$K$17,$J$6:$J$17=$J6)))="RS")A second one for the opposite side.
note this will highlight BOTH if this row has LS or the matching other row has RS
See attached.
Millertime9460 Here is one option (it assumes you have excel 365). Custom formula in conditional formatting:
=($K6="LS")+($K6<>"RS")*(TRIM(CONCAT(FILTER($K$6:$K$17,$J$6:$J$17=$J6)))="RS")A second one for the opposite side.
note this will highlight BOTH if this row has LS or the matching other row has RS
See attached.
Wow, that worked! Thanks a bunch!