Exceptions wrong colors

[Former Member]

Hi

did you ever notice errors in BEX expcetions?

In particular results wrong colors ... (pink on the results in spite of red and green )

How can i solve this "bug"

Thanks in advance.

[tom_francis2 · Accepted solution]

Go to the cell with the 'wrong' color.

Choose format style from the menu, and change it like you want.

If you want this to be the final state you will have to change the workbook template.

kr,

Tom

[andrea_previati]

Thank you for your useful suggestion ... (in reality i used a more complex exception classification criteria based on different sublevels either for bad results and good results ) Now i will use only the bad 9 level for the third class

Is this valid also for the others colors ?

[former_member188975]

Yes, you get 3 shades of green and 3 of yellow when you use levels 1 to 6 of the execeptions. For the 'pure' green use level 1 and for Yellow use level 4.

Hope this helps...

[andrea_previati]

Hi

I have a ABC Analysis query with tree levels on totals

0-30 Red

30-60 Yellow

60-100 green

[former_member188975]

Hi Andrea,

My reason for asking was just to confirm whether you have the Bad 9 level assigned, as this is the only one that will give you the Red color...other Bad levels deliver you shades of pink.

[andrea_previati]

Thanks for the replies

I have already tried to solve the wrong colors exceptions with the format option in Bex but in this way the conditions imposed are not respected.

(for instance all the 350/400 results are in green or in red )

Regarding the second suggestion i must say that the range of conditions is correct but still the results colors are wrong.

In a previous project i applied in this case a custom vb macro but in this case this solution is not possible.

[former_member188975]

Hi Andrea,

For the results that you are expecting to see as Red, what Exception level have you assigned?

[Former Member]

i have seen this happen when two different conditions specified are valid for same figure in the result.

e.g.. lets say my total result is 5 in the query

i have set 1-10 as green

4-6 as red

its going to apply both to my result as both are valid for 5 and resulting color is something like pink

hope you find it useful

regards

sharan