Colouring Specific Months Using Expression in Background Colour

[#1]

We have a Straight Chart in horizontal format.  Using expressions we have data rows of inventory data in monthly bucket columns.

We want to use the background colouring to identify (visual clue) when the freeze fence (lead time) from the current month.

For example:

If this was month 6 (June) and the Freeze Fence is 3 months - therefore, the cells in months 6, 7 & 8 should be purple and months 1-5 and 9-12 would remain grey

Month1	Month2	Month3	Month4	Month5	Month6	Month7	Month8	Month9	Month10	Month11	Month12
100	50	50	75	100	50	50	100	75	100	50	50

Needless to say each SKU will have it's own freeze fence of 0 to whatever so we do not want to colour the header.

I'm hung up on the IF statement ... currently I have

if  ((CalMonth) < (FreezeFence), RGB(90,0,150),  RGB(100,100,100) ) 

Just having a brain fart on the logic - I know I need to add the freeze fence value to the month number less 1, then colour those months purple and the rest gray.

Please and Thank you in advance!

DD

[#2 · Accepted solution]

Hi,

Please look at attached document. Special case is when the freeze goes over into the next year.

I've solved that by checking if the freeze goes over the next year.

Kind Regards,

Dion

[sujeetsingh]

Well reply by Deon!!

[#4]

Hi Dion! Thank you so much for your help!  It worked great with a little tweaking specific to our need.  I'm terribly sorry for the delay - work - life - stuff - got in the way!

Have a grrreat day!

Däv