Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Background Color based On Variance

If I split the following formular for each green or red it works. But if i use as a one statement like below, won't work. Appreciate if you could help.

(([Act-Sep14]-[Bud-Sep14])/[Bud-Sep14] >.15, Green()) or if(([Act-Sep14]-[Bud-Sep14])/[Bud-Sep14] <0, Red())

1 Solution

Accepted Solutions
danieloberbilli
Specialist II
Specialist II

the 'or' is wrong syntax, try:

Capture5.PNG.png

View solution in original post

2 Replies
danieloberbilli
Specialist II
Specialist II

the 'or' is wrong syntax, try:

Capture5.PNG.png

Not applicable
Author

It is right, Thanks very much