For the Conditional formatting you can refer here:

https://www.myonlinetraininghub.com/excel-conditional-formatting-highlight-matches-in-list

  Hello Sunny;

          This is Mitul.

          Good Morning

           How are you ?

     Thank you  for sending me article on  conditional formatting formula. I  am looking for article on how to compare 2 lists  using conditional formatting
      formulas.  Also, this morning (especially New York, USA morning, I placed 2 new posts here , entered sample data of  what  cond. form. formulas to  write for those 2 scenarios, so  can you  please help me out.  
  

  Also,  yesterday, I attached 1 Getpivotdata file in which I am keep getting #REF! error,I tried best, but I could not get desired  result.

  Thank you very much.

   Have a great day.

  Sincerely;

   Mitul.

Hello Mitul,

To start with, this article describes why you get a #REF! error and how you can correct it.

Secondly, this article describes the GETPIVOTDATA function. Another article, in my view a better one, is written by Mynda and you find it in the blog section or by clicking on this link.

Lastly, the error you made is that you use SALESPERSON as a field reference when the actual name in the Pivot Table is Name. So change following

=(GETPIVOTDATA("Sum of Dollars",$R$8,"SALESPERSON","Jen","Product","lipstick"))

to

=(GETPIVOTDATA("Sum of Dollars",$R$8,"Name","Jen","Product","lipstick"))

and you will get the result, which is 3953.300132.

Even if you change name of any header in the Pivot Table, you need to stick with the headers you have in the table columns when referencing to them.

Br,
Anders