Conditional formatting across sheets based on cell value

Hi All

I am new to VBA and would like a little help with a challenge that I am facing.

I would like to apply a conditional format to a number of cells based on another cells value.

For example if

Sheet 1 cell B2= "1" then I would like to colour the interior of cells "D5:E5" on sheet2 blue (colour index for this is 12611584 if it is needed).

This would then go on to look sheet1, cell B3 and would format sheet2 cells "F5:G5" and so on...

If this could be attached to a button also that would be even better

If any one could help me with this it would be great!

Thanks in advance for any help that can be offered

Maybe:

Please Login or Register  to view this content.

Hi John

Thank you for your quick reply. I have added in the code and it is not doing what i thought. I think that I may need to add a little context to what I am aiming to do with this.

Sheet 1 contains the data for an agents attendance 1=Out Of Office 0= In the office, this is then sorted by agent by date
Sheet 2 contains open and booked appointments for an agent in a similar format; the Idea is that if an agent is marked as out of the office then the day on sheet 2 is formatted to highlight this.

I hope that this helps.

Thank you again though

Regards

Dominic