Forum Discussion
Solved
HOW TO HIGHLIGHT THE KM LOCATION IN A SECTION IF IT IS IN SANCTIONED LOCATION LIST?
I am working on highlighting a cell with some conditions below These are two data sets I have. the second one is sanctioned km list for works. Now I want to highlight cell in column ...
=MATCH(1,(J287>=Tabelle2!$T$406:$T$424)*(J287<=Tabelle2!$U$406:$U$424)*(C287=Tabelle2!$J$406:$J$424)*(E287=Tabelle2!$L$406:$L$424),0)You can try this rule for conditional formatting which works in my sheet. The sheet names "Tabelle1" and "Tabelle2" have to be replaced with the names of the actual sheets.
=MATCH(1,(J287>=Tabelle2!$T$406:$T$424)*(J287<=Tabelle2!$U$406:$U$424)*(C287=Tabelle2!$J$406:$J$424)*(E287=Tabelle2!$L$406:$L$424),0)You can try this rule for conditional formatting which works in my sheet. The sheet names "Tabelle1" and "Tabelle2" have to be replaced with the names of the actual sheets.
- Thank you OliverScheurich. Your solution helps me alot.
