Color Cell Formula is not working, any help please?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

I'm trying to create a Rich Text Formula fields called "Cell Color for Days Past ISD"  that will color the cell "Days Past ISD" which is is a formula - duration field. If the days are under 120, they should remain white. If the days are between 121 and 180, it should be orange. If it is over 180 days, the cell should be red. This is the formula I have written for it:

[Days Past ISD] > Days(0) and [Days Past ISD] <= Days(120), "0-120",
[Days Past ISD] > Days(120) and [Days Past ISD] <= Days(180), "<div style='font-weight: bold; background-color:#ED9121; '>" & "121-180" & "</div>",
[Days Past ISD] > Days(180), "<div style='font-weight: bold; background-color:#EE3B3B; '>" & ">180" & "</div>", null

However, it won't do anything to the field "Days Past ISD", it will only change the color cell of "Cell Color for Days Past ISD".

Any help?

Thank you!

Photo of Iris Bonilla

Iris Bonilla

  • 320 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,658 Points 10k badge 2x thumb
Hi Iris,

A formula field set up for colorization will only color that specific field that contains the colorization formula. It will not colorize another field outside of the field that contains the formula. You can set up colorization on a report for an entire row but there is not an option to colorize another field separate from the field that contains the colorization formula. I hope this information is helpful Iris and thank you for your time today. 
Hi Iris, Evan is spot on.

I have a video on how to do the report colorization here if you need it:

You could reference the Cell Color for Days Past ISD field you've already created, like such:

Case([Cell Color for Days Past ISD],"121-180","#ED9121",">180","#EE3B3B")