Change Font Color

[yashcena]

Hi,

I have a chart where I'm projecting available hours of resources for the future.

It looks like this:

In the week of 09/30, the availability increases by 2 hours. So I want the text color to change to black.

When the availability changes again, I want the text color to change black to red.

I have written simple expressions for background and text color of the chart-expressions (shown below) but I'm not able to include the functionality of changing colors with changing availability.

Background:

=IF ($(vRemainingHours)<0,RGB(0,0,0),

IF(($(vRemainingHours)>=1 and $(vRemainingHours)<=6) ,RGB(177,106,103),

IF(($(vRemainingHours)>=6.1 and $(vRemainingHours)<=13),RGB(244,156,89),

IF(($(vRemainingHours)>=13.1 and $(vRemainingHours)<=20),RGB(255,217,99 ),

IF(($(vRemainingHours)>=20.1 and $(vRemainingHours)<=27),RGB(206,247,129),

IF(($(vRemainingHours)>=27.1 and $(vRemainingHours)<=35),RGB(79,170,115),

IF(($(vRemainingHours)>=35.1 and $(vRemainingHours)<=42),RGB(179,224,245),

IF(($(vRemainingHours)>=42.1 and $(vRemainingHours)<=49),RGB(154,155,156),

IF($(vRemainingHours)>=49.1 ,RGB(0,0,0)

)))))))))

Text:

=IF ($(vRemainingHours)<0,RGB(255,0,0),

IF(($(vRemainingHours)>=1 and $(vRemainingHours)<=6) ,RGB(255,255,255),

IF(($(vRemainingHours)>=6.1 and $(vRemainingHours)<=13),RGB(0,0,0),

IF(($(vRemainingHours)>=13.1 and $(vRemainingHours)<=20),RGB(0,0,0),

IF(($(vRemainingHours)>=20.1 and $(vRemainingHours)<=27),RGB(0,0,0),

IF(($(vRemainingHours)>=27.1 and $(vRemainingHours)<=35),RGB(255,255,255),

IF(($(vRemainingHours)>=35.1 and $(vRemainingHours)<=42),RGB(0,0,0),

IF(($(vRemainingHours)>=42.1 and $(vRemainingHours)<=49),RGB(255,255,255),

IF($(vRemainingHours)>=49.1 ,RGB(255,255,255))))))))))

$(vRemainingHours) is my chart-expression.

The condition to change the text color should be added in the text color-expression.

Also, is there any other/better way to depict availability change in the above chart so that it's more visually attention-catching?

Any help would be appreciated!

Thanks,

YASH