Google Sheets Timeline - Conditional Formatting not working :(

Hi all,

Just wondering if anyone can help with this... I have previously built interactive timelines using Excel & Google sheets that incorporate conditional formatting based on START & END dates based on 2x cells.

For some reason when I've tried to put a new one together the conditional formatting does not seem to be working.

The formula I'm using is;

=AND(S$8>=Q$10,S$8<=R$10)

Which is applied to the range S10:RH1999

As far as I can see this SHOULD work, any help here would be much appreciated!

Thanks
Jack

Try changing the formula to use Boolean arithmetic structure, like this:

=(S$8>=Q$10)*(S$8<=R$10)

Are you able to provide a link to sample/copy of the file?

(just break up the link with spaces and put (dot) for the dots)

Hi Jack,

Here is working formula, already keyed into your file:
=AND(S$8>=$Q10,S$8<=$R10)

this will also work:
=(S$8>=$Q10)*(S$8<=$R10)