Hello all,
On the attached file, how can I use the status Rag in column E to also show up on the periods that are highlighted on the right-hand side?
Currently, I get either all cells highlighted with the status colour or none. I cannot see which part of the conditional formula I need to update...
The picture below is for convenience.
