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.