Aug 10 2022 11:28 PM
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 J in first sheet if it is in between cells T & U in second sheet with in same section and line (i.e., Column C&E in sheet 1 should match with Column J & L in sheet2).
I have been trying using if conditions, vlookups, index functions. but could not highlight the cells. Can anyone help me on this?
Aug 11 2022 12:20 AM
Solution=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.
Aug 12 2022 02:28 AM
Aug 11 2022 12:20 AM
Solution=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.