Conditional formating of a plage of cells (dates) based on dates of events (begining and ending) fin

Copper Contributor

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.

1 Reply

@BenjROLL 

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?