Skip to Content
avatar image
Former Member

EPMFORMATTINGSHEET - HIGHLIGHT only Current TimePeriod in SAP IBP Excel

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 07, 2017 at 08:08 PM

    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"

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 07, 2017 at 08:01 PM

    Use Excel conditional formatting with the formula!

    Add comment
    10|10000 characters needed characters exceeded