Forum Discussion
Formula - timline with additional dates
Hi,
I have a set-up calendar which highlights the cells based on the value in column B (start date) and column C (end-date). Like timeline. This is the formula I'm using
=IF(AND(L$5>=$E29,L$5<=$F29),"X","")
Now I am also required to highlight a single date from columns D,E and F.
How I can do that?
Thank you
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'.
6 Replies
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.
