Forum Discussion

IrisBonilla's avatar
IrisBonilla
Qrew Cadet
7 years ago

Color Cell Formula is not working, any help please?

Hello, 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 ...
Formulas and functions
QuickBaseJunkie's avatar
QuickBaseJunkie
Icon for Qrew Legend rankQrew Legend
7 years ago
Hi Iris, Evan is spot on.

I have a video on how to do the report colorization here if you need it: https://www.quickbasejunkie.com/blog/how-to-color-code-rows


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")