Hi Team,
I need your help in applying conditional formatting rules and highligting entireRow in Yello Color,
I have validation list in cell J2(Regions List) and K2(Products List).
I tried this formula =AND(a2=$J$2,b2=$k$2), but not working. plz assist,
Below is My Data,
In sheet1,Column A Consist of Regions (North,South,East,West) and
Column B Consist of Products Say (ABCD, EFGH, JKLM, PQRS,) and
and Columns (C,D) Consist of some data,
Regards,
mg
I need your help in applying conditional formatting rules and highligting entireRow in Yello Color,
I have validation list in cell J2(Regions List) and K2(Products List).
I tried this formula =AND(a2=$J$2,b2=$k$2), but not working. plz assist,
Below is My Data,
In sheet1,Column A Consist of Regions (North,South,East,West) and
Column B Consist of Products Say (ABCD, EFGH, JKLM, PQRS,) and
and Columns (C,D) Consist of some data,
Regards,
mg