Help! scratching my head all day!
I'm looking for a conditional format formula which would result in the attached image;
If "Tentative" (as DB4), colour CP4 based on the value in B4.
In English, If a Cell is "Tentative", look back 12 cells (based on changeable figure in B4) and colour accordingly.
I can add a hidden reference row if required in Row 5
As always thank you for any help you can offer, I'm trying to learn