Just want to colour a single field it's a little more complicated than XL. You're actually need to create a formula rich text field and use a formula as described here.
https://help.quickbase.com/user-assistance/color-coding_fields.htmlHere is another example
Background Shading
var text ColorCode =
If(
[Delivery Date]-Today()<Days(1),"pink",
[Delivery Date]-Today()<Days(3),"yellow",
[Delivery Date]-Today()<Days(5),"green");
var text DateText = ToText([Delivery Date]);
Case($ColorCode,
"pink","<div style=\"background-color: pink;\"" & ">" & $DateText & "</div>",
"yellow","<div style=\"background-color: yellow;\"" & ">" & $DateText & "</div>",
"green","<div style=\"background-color: #00C957;\"" & ">" & $DateText & "</div>", $DateText)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 01-05-2022 17:40
From: Unknown User
Subject: Formula: Color Coding and Dates
Thank you! Do you know if there is a way to color code the numbers in a field? For example, an employee has worked for 5-10 years the field would be green, etc.
Original Message:
Sent: 01-05-2022 14:57
From: Mark Shnier (YQC)
Subject: Formula: Color Coding and Dates
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=d611e107-d1df-4e72-aab6-16514a05cdba&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer&bm=d611e107-d1df-4e72-aab6-16514a05cdba#bmd611e107-d1df-4e72-aab6-16514a05cdba
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
Original Message:
Sent: 01-05-2022 14:52
From: Unknown User
Subject: Formula: Color Coding and Dates
Hello All! I am new to Quickbase and I am having trouble finding out how to code. I need to make a report that tracks all employees and how long they have worked at my company. I have the basic information, (I.e. Start date, employee, etc.) but I was wondering of there would be an easier way to automatically calculate how long the employee has worked from when they were hired until the present date. I also need to find out how to code those times in to different sections (green= 0-1 years, blue= 1-5, etc) so I can graph that info. If anyone has any suggestions or can point me in the right direction to go that would be amazing! Thanks