Forum Discussion
Conditional Formatting
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.
- mtarler How similar would it be if I wanted to do the same thing for "DONE"? If I make one row "DONE," it also matches its duplicate WireID as "DONE."
Millertime9460 should be nearly identical:
=($K6="DONE")+($K6<>"DONE")*(TRIM(CONCAT(FILTER($K$6:$K$17,$J$6:$J$17=$J6)))="DONE")the TRIM(...) is just in case they have a space instead of an empty cell but you could also do something like:
=ISNUMBER(SEARCH("DONE",CONCAT(FILTER($K$6:$K$17,$J$6:$J$17=$J6))))so that if they say DONE ALL or DONE BOTH it still works in either or both locations.
A similar trick could be used on the RS and LS items but would need to be done for each part since they are looking for different things.
mtarlerIf I want the corresponding row highlighted to return "DONE" in the status bar, how would I go about that? On my work computer, I've got a column that calculates the % of each row based on the text in the status column. So "DONE" would return 100%, "LS" or "RS" would return 50%. When the other end of the wire's corresponding row is highlighted, the % completion column doesn't recognize that it's really "DONE," so it won't return 100%.
- Wow, that worked! Thanks a bunch!
