Forum Discussion
Formula - timline with additional dates
I didn't enter any formulas in the cells.
Select cell L9, then on the Home tab of the ribbon, click Conditional Formatting > Manage Rules...
You'll see the 4 rules that I created. They're all of type 'Use a formula to determine which cells to format'.
Which date do you want to highlight?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar Thank you for your reply.
I would like in cells L till JK (calendar) to show the timeline based on the column Active Start Date and Avtive End date but also highlight in that calendar dates from columns D,E and F.
https://docs.google.com/spreadsheets/d/16QusoS_cDPN2DGwlG-9j-rCyvZW2eW6M/edit?usp=sharing&ouid=111731776218250181490&rtpof=true&sd=true
I hope this makes sense
Thank you
I assume that you mean columns H, I and J instead of D, E and F.
And that the start date in E9 should be in 2023.
See the attached workbook.
- This is exactly what I'm after.
Thank you!
Please how I can replicate this in the original tracker? (unfortunately I cannot see any formula)
