Hello,

I would like to write a VBA macro with a button command to change the background colour of cells in the last active row in a range in sheet 2 Range (A1: A8) only if the cells in a range (A1:A5) in sheet 1 are the same as in sheet 2 .

As follow:

Sheet 1
A1 A2 A3 A4 A5
1 2 3 4 5

Sheet 2
A1 A2 A3 A4 A5 A6
12 3 1 7 2 9

If value in A1 sheet 1 in range A1: A6 in sheet 2 colour red else the blanks
If value in A2 sheet 1 in range A1: A6 in sheet 2 colour orange else the blanks
If value in A1 sheet 1 in range A1: A6 in sheet 2 colour yellow else the blanks
If value in A1 sheet 1 in range A1: A6 in sheet 2 colour blue else the blanks
If value in A1 sheet 1 in range A1: A6 in sheet 2 colour green else the blanks

Example:
In our example: A3 background in sheet 2 would be red
In our example: A5 background in sheet 2 would be orange
In our example: A2 background in sheet 2 would be yellow
The other cells in sheet 2 ( A 1, A4, A6 ) would stay the same

Can anyone help?

Thanks in advance

Bruno

Hi Bruno,
I think some aspects of your post contradict others but I have the picture.

Sheet 1 has values and sheet 2 has the look-up Range you colour based on.
For each myValue in myValues
For each myLookup in myLookups
If if myValue = my lookup then
MyValue.color = green
And so on and so on.

__________________
Nostalgia 4 Infinity