Hi All
I am really 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 Sheet 2 based on the cells values on sheet 1.
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).
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. 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
I am really 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 Sheet 2 based on the cells values on sheet 1.
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).
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. 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
