Conditional Formatting issue

You might want to try changing the numbers to:

Min: -0.01

Mid: 0.5

Max: 1.01

Also, you should also turn off the summary, because a percentage larger than 100% for parents isn't meaningful.

Thanks,

LipChean

1.1. Value line item - is where you set the conditional formatting, correct? Value line item is where you enter the % percentage.

2. %CF - is used to check if the total at parent level is 100%,right? Yes, and whether there's any input in 'Value', it doesn't make sense to set a blank cell to red, even if the parent is larger than 100%, right?

3. the screen shot on number 2 - is this the part where you tell the user that it exceeded 100% already?

Yes, and I created a few more examples below.

Thanks,

LipChean

All comments

You might want to try changing the numbers to:

Min: -0.01

Mid: 0.5

Max: 1.01

Also, you should also turn off the summary, because a percentage larger than 100% for parents isn't meaningful.

Thanks,

LipChean

Akhtar.shahbaz

Add one line item for the conditional formatting where you have to write the rule for share % & used this CF line in your conditional formatting.

Thanks

Akhtar

Hi LipChean,

First of all thank you for taking time in responding to my concern. However, when I entered 100% to the next cell it turns to white. How can I make it turn red. see below

to alert the user that they cannot enter 100% anymore.

Regards,

Hi Akhtar,

do you mean like this. see below. another line item and then in the conditional formatting i will use this line item instead of share%?

1. Assuming 'Region L1' is the parent of 'Country L2'.

2. Assuming 'Value' is where you enter the %.

3. '% CF' is used to check whether the total % at parent level is more than 100%. Note that i have added another test to ensure only cells with values are highlighted in red, i.e. blank cells do become red.

4. A System module is created to follow DISCO.

Thanks,

LipChean

My apologies just a couple of questions more.

1. Value line item - is where you set the conditional formatting, correct?

2.%CF - is used to check if the total at parent level is 100%,right?

3. the screen shot on number 2 - is this the part where you tell the user that it exceeded 100% already?

Regards,

1.1. Value line item - is where you set the conditional formatting, correct? Value line item is where you enter the % percentage.

3. the screen shot on number 2 - is this the part where you tell the user that it exceeded 100% already?

Yes, and I created a few more examples below.

Thanks,

LipChean