Change colour of a cell if the the date of another cell if found in a list of dates

Surferol

New Member
Joined
Apr 9, 2021
Messages
17
Office Version
  1. 365
Platform
  1. MacOS
Hi guys,
I'm sure this is pretty basic question, but I seem to be struggling to make it work.
I have my work schedule which automatically populates and changes the cell colour if I am working on a particular date.
I would like to have a list of dates for my leave outside the calendar and the colour changes if that day is in the list of dates.

Screenshot attached shows January next year. I am due to be working 8th to 11th January as it is green. The list at the side is the days leave I wish to take, if the date of the cells are in that list I would like it to change colour to red not green.

Thanks.
 

Attachments

  • Screen Shot 2021-06-20 at 18.18.06.png
    Screen Shot 2021-06-20 at 18.18.06.png
    116.2 KB · Views: 14

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,224,823
Messages
6,181,182
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top