Excel-Conditional formatting Rules help

[Mallesh23]

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

 

[DanteAmor]

Try this

-Formula:
=AND($A2=$J$2,$B2=$K$2)

-Applies to:
=$A$2:$D$100

 

[Peter_SSs]

Bit hard to tell without seeing some data, but try this

I tried this formula =AND($a2=$J$2,$b2=$k$2)

 

[Mallesh23]

Hi Peter and Danteamor,

Thanks for your help, but I am doing some mistake , i dont know Where I am doing that,
Attached snapshot, Data and Validation list (validation list taken near)

Regards,
mg

 

[Peter_SSs]

If you posted that sample using XL2BB (see my signature block below) it would be easy for us to see what is going wrong.

 

[DanteAmor]

Select the cells where you want to apply the format.

And

Check the sign

Formula:
=AND($A2=$J$2,$B2=$K$2)