Highlighting cells between columns in a row

Hi there,

New to the forum - hoping you can help me do something in excel, or tell me whether it is possible!

I have a list of rows of events, the next column is start date and the next column is end date. After that I want to make this data visual, so each column is a chronological list of dates 1900 | 1901 | 1902 ...etc.

I started manual highlighting these date cells, row by row, for each event, but it is pretty laborious. A lot of scrolling left and right.

Is there a way to automatically highlight those cells according to the start and end date?

Thanks forum!

It is possible. Post a sample file as per the yellow banner above and we can assist further.

Thanks for such a quick reply! I've knocked up a similar smaller example and hopefully that is attached!

Hi ALiGW,

Thanks for that! I might need a bit more help in using it, I'm not great at Excel. I tried pasting your formula in E2 and dragging it to apply across rows and columns, it fills each cell with FALSE. Not sure how to use it correctly!

Oh wait, sorry, just saw you attached an example! Thanks!

Thank you so much! I just applied that to my original document and it works a treat!