Conditional formatting based on sql query result

Question

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

How would you do that?

Bob Swift · Answer

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.