Forum Discussion
Solved
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<=...
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'.
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)
Thank you!
Please how I can replicate this in the original tracker? (unfortunately I cannot see any formula)
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'.
- Thank thank so much.
I really don't know why I didn't think of conditional formatting - again thank you so much!