EPMFORMATTINGSHEET - HIGHLIGHT only Current TimePeriod in SAP IBP Excel

[Former Member]

Hi there,

How can we dynamically highlight only current TimePeriod ID in SAP IBP (see image attached as example)?

From what I see, it's only feasible by targeting exact time period (ex: 70570 for June), which is not dynamic at all since the customer would have to modify it every new month.

As my last EPM question stayed unanswered, I hope I will have an echo from this one.

Thank you again guys!

[former_member186338 · Accepted solution]

Sample conditional formula:

=IF(C1=MID("JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC",(MONTH(NOW())-1)*3+1,3)&" "&YEAR(NOW()),TRUE,FALSE)

Assuming C1 is the cell with month like: "JUN 2017"

[Former Member · Accepted solution]

It definetely works! You are a boss Vadim!

[Former Member · Accepted solution]

Thank you!

[former_member186338]

Use Excel conditional formatting with the formula!

[Andrei_Lupu]

This is an old question, but perhaps someone is still googling it: example on how to format the current Calendar Week header below