# Using colours in reports

**URL:** <https://community.spicecrm.io/t/using-colours-in-reports/295>\
**Category:** Uncategorized\
**Created:** [May 5, 2018, 9:57am UTC](https://community.spicecrm.io/t/using-colours-in-reports/295 "2018-05-05T09:57:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jonnie00](https://avatars.discourse-cdn.com/v4/letter/j/85e7bf/32.png) [@jonnie00](https://community.spicecrm.io/u/jonnie00)\
**Post date:** [May 5, 2018, 9:57am UTC](https://community.spicecrm.io/t/using-colours-in-reports/295/1 "2018-05-05T09:57:51Z")

</div>

I have a report where we use a colours to categorise and outcome of an intervention we run, (i.e.red, amber, green).

Using the store and formula fields and this code I have managed to change the text colour when RED is the outcome. How do I also do this for the other outcomes (AMBER AND GREEN) in the same formula? Also, how do I make that field text bold?

Code: ({outcome} ==“RED”? “”.{outcome}."" : {outcome})

Also, is it possible to colour code background of the entire record? i.e. When the outcome is green, make the background green?

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/40c554216f3ca9d1e1ed15a5ef8989c3d7a597e6.png)

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [May 8, 2018, 6:55pm UTC](https://community.spicecrm.io/t/using-colours-in-reports/295/2 "2018-05-08T18:55:38Z")

</div>

Jonnie,  
have a look at best pratice example described in  
[https://spicecrm.gitbooks.io/kreporter-4-x/content/advanced/formula.html](https://spicecrm.gitbooks.io/kreporter-4-x/content/advanced/formula.html)  
Try a span Tag with style attribute.

Val