Conditional Formatting report

[RoryF]

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 · Accepted solution]

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>>

[RoryF]

That sound very creative - I like it.. I'll give it a shot..

Thanks..

[RoryF]

That works.. thanks.  The problem is it leaves a lot of white space between rows but that is down to the long column names - I will work on that..

Regards,

RoryF