Forum Discussion
Solved
How do I colour a cell based on text and a date range in a Gantt chart?
Hi there, I'm looking for help working out how to do the below. Here is the set up: Column A - Event title Column B - Organiser Column C - Start date Column D - End date From Column F is ...
=AND(F$6>=$C8,F$6<=$D8,$B8="Dave")
This is the rule for Dave in the attached sample file. For every different colour you have to enter a seperate rule for conditional formatting.
=AND(F$6>=$C8,F$6<=$D8,$B8="Dave")
This is the rule for Dave in the attached sample file. For every different colour you have to enter a seperate rule for conditional formatting.
OliverScheurich It works! Thank you so much, I really appreciate you taking the time to answer my question.