Split Dates

Hargreaves

Hi

I am trying to get if split dates is in the last 7 days go orange and if split dates is 8 days in the past go red but it wont work it focus on the over the past 7 days only

I enclose a image of my conditional formatting.

Tomasz Giba

Hi @Hargreaves

Try to move 8 days rule up.

Let me know if that works?

Thanks!

Hargreaves

Unfortunately doing what you advise turns all the Split dates Red not Orange for less than 7 and Red for less than 8 we need to differ the 2 for KPIs / Targets for deliveries.