Skip to Content
Author's profile photo Rahul Handa

Macro – Set Foreground Color of a Cell

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:

Macro 1.JPG

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).

Macro 1.JPG

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

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Christopher Smith
      Christopher Smith

      Good post, found this helpful!  Thanks for the examples