Conditional formatting based on sql query result

[Kfir Ratson]

Hi,

I am using the SQL Macro to get results from a database.

What is the way to color each result based on the value returned from my query?

So for example, if I get value > 50, color the cell background in Red and if < 50, color the cell background in Green...

Thanks!

[Eugene Domingo]

How would you do that?

[Bob Swift OSS (Bob Swift Atlassian Apps)]

Use a case statement in your sql to distinguish the cases and apply the appropriate surrounding text. The easiest way is to use output=wiki and the color or similar macros.