Supply Chain Management Blogs by Members
Learn about SAP SCM software from firsthand experiences of community members. Share your own post and join the conversation about supply chain management.
Showing results for 
Search instead for 
Did you mean: 
Active Contributor

As we saw in Macro - Set Background Color of a Cell that we set the background color of a cell when specific condition was not meet. Same way we can set the foreground color of a cell instead of background color.

In this example we will use CELL_FG instead of CELL_BG function. First we define a default macro for the same as below:

Now we see the effect of the same while doing interactive planning. Instead of background we have foreground color change where condition is not meet (i.e. where CF > PF).

For different colors here are the values which you can maintain in macro:

Black if X = 0

Blue if X = 1

White if X = 2

Yellow if X = 3

Cyan if X = 4

Green if X = 5

Red if X = 6

Magenta if X = 7

Deep blue if X = 8

Gray if X = 9

Bright yellow if X = 10

Intensive cyan if X = 11

Intensive green if X = 12

Deep red if X = 13

Deep magenta if X = 14

1 Comment
Labels in this area