Conditional background using if statement; want to ignore selections?

[#1]

Hi All

I have a table whose expressions have set analysis to ignore any selections in a field called period, like :

Sum({$<Period=>} Actuals)

I have a conditional formatting function for the background of this like:

[CODE]if([4AN - Level 4 Account Name]='Income',RGB(199, 250, 254),if([4AN - Level 4 Account Name]='Non Pay Costs',RGB(255, 202, 202),if([4AN - Level 4 Account Name]='Pay Costs',RGB(185, 255, 185),RGB(205, 201, 201)))) [/CODE]

The problem I'm having is when people are selecting in Period the expression is giving the same result but the conditional formatting is changing? E.g. it will be showing the income colour, make a selection in period it shows (for some entries) the colour of the default, that is the last RGB value in the nested if?

Please can anyone advide on how to get this to work please?

Thanks

Dominic

[maneshkhottcpl]

Hi, If u send me the application , i can surly help u.

[#3]

Sorry, it contains confidential info; however I can help with any questions you need answering?

[maneshkhottcpl]

Hi Ok but u can send me a scrambled data.

or sample application with few data.

Or explain more about the situation.

[#5]

This demonstrates the problem; when you select an entry from F1 the conditional formatting changes. Thanks.