Please tell me the V.B code to change the b.g color of cells based on same values in another sheet : I am trying to change the background colour of certain cells in sheet 1 based on the same set of values in the sheet 2.

I want it to search the values in sheet 2 to sheet 1, if the values are same then the colour should change.

I have used conditional formatting but things are not working. Please help