Forum Discussion

Kinaia's avatar
Kinaia
Copper Contributor
Feb 08, 2024

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

  • Kinaia 

    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'.

Resources