Forum Discussion
Formula
Sasha0509 I'm not exactly what you mean by triggered but here's a formula that will return the value in column M based on a partial match by combining columns A & B (placing a period in between those values) and comparing against column L.
Conditional formatting is then used to make the cells green when the trigger condition is met.
If this isn't what you're looking for, would you please share screen shots or upload a sample file?
Sasha0509 I'm not exactly what you mean by triggered but here's a formula that will return the value in column M based on a partial match by combining columns A & B (placing a period in between those values) and comparing against column L.
Conditional formatting is then used to make the cells green when the trigger condition is met.
If this isn't what you're looking for, would you please share screen shots or upload a sample file?
- Sir, you are a wizard. I will test it to see can I apply it but this is definitely way to go. Thank you very much.
