Solved: Conditional Formatting report - Page 2

RoryF · 03-17-2022 02:04 PM

Hello All..

I have a question regarding "Conditional Formatting" of reports - I have a feeling that this is not possible but doesn't hurt to ask..

I have a simple report which is working as expected (I have it emailing when needed). First screen shot. What I would like to do is to format the entire row in RED IF the "Urgency Level" is above a certain number (7 or 8). The 2nd screen shot is how I would like it. The 3rd screen shot is the Email template document that I am using.. Very simple.

So I am wondering if this is possible?

Thanks,

RoryF

SkrOYC

You can't do it using that template but try this workaround:

Add two [ShortDate], [Name]. [Is...] and [What..] (Also try to change those column names, for long messages use the Display Name field under the editor)

One of them would be this way:

<<If:([What is the urgency level? 1-10]>6)>><<[Name]>><<EndIf>>
<<If:([What is the urgency level? 1-10]<7)>><<[Name]>><<EndIf>>

View solution in original post