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!