Bulk applying conditional formatting in WebI

[former_member337757]

I am using SAP Web Intelligence Build 14.1.4.1729

I have a report that elements such that they may count as individual cells. The thing is all of them are numeric. I want them to turn Red if they are less than 0.

Now I have a formatting in place, but i have to go individually to each cell, right click and apply it. It doesn't seem smart.

I tried searching up on it, but there wasn't anything about this issue.

Is there a simpler way? Am I missing something?

[former_member183161 · Accepted solution]

hi pratiksha ,

use the  conditional formatting option here  on the particular object with where condition instead of each  cell.

[former_member337757 · Accepted solution]

The Conditional formatting is on the condition of < 0, but its based on cell contents. I have more than 50 variables scattered all over the report, I have to include them all in the condition if I want it to automatically turn red.

I guess some grunt work is in order, thank you anyway.