Forum Discussion
Conditional formating of a plage of cells (dates) based on dates of events (begining and ending) fin
Hello,
Is it possible to create a rule with a formula in order to do a conditional formating (colloring) of a plage of cells (dates) based on dates of events (begin and end) findable in a table ?
For now, my formula (which doesn't work) is :
AND($H$9 >= Tableau22[@[Date Begin]]; $H$9 <= Tableau22[@[Date End]]).
I have a solution (which work) :
=AND(H$9 >= $D$9; H$9 <= $E$9).
The problem is that for it to work it need to be put line by line. I would like to select the whole plage and that the conditional formating works for all cells. I would allow to add new event without having to create a new formating rule.
Thanks for your time.
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?