See if you like this a little better:
If([qb status]="Open", "<div style=\"width:70px;padding:3px;background-color:green;color:white\"> Open</div>", [qb status] )
In the report settings, use this syntax for highlighting a row:
if ([Priority] = "High", "pink", "")
You can use hex code for color if you want to, "#cc66cc", etc.
So click on the table tab where you want to create a new field. Then click "Settings" at the far left underneath the table name.
On the next page, select "Fields".
On the Fields page, click the green button, "+New Fields"
You want to create a formula text field.
Paste in the code provided, check box the option to allow HTML.
Click SAVE.
Insert your new field into the report.
HTML will not export to csv.
