****SAP BO - Conditional Formatting Related Query******

[rohitsapbi]

• Hi Team, On SAP webi report i need to show some value in blank cell based on Conditional Formatting/formula 
• I want to show in a cell, if my variable value more than 100 then Green, below 100 then red , equal to 100 than amber and final condition if my variable through value as N, it must return N/A too in the same cell.

Iam trying this on sap BO 4.3 version.

[ayman_salem]

I added “SAP BusinessObjects – Web Intelligence (WebI)” to the tags

[ayman_salem · Accepted solution]

1. Insert  new column into the table

2. Select the new column and then choose "Formatting Rules" from the pop-up menu

3. Create new rules with conditions

4. OK

 

5. Result

...

I hope the steps are clear

[rohitsapbi · Accepted solution]

Thankyou for your valuable time and efforts. This really worked for me.

[ayman_salem]

Is this what you need:?

[rohitsapbi]

Yes Indeed, Can you share me the workflow of it.