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.

​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.  Read More

​