Color Coding of reports, but only high light the cell in question

You would need to create a new formula field.  I usual name them like [Field A.] with a period so I know it's a mirror type field.  The use this syntax.

https://helpv2.quickbase.com/hc/en-us/articles/4570255561108-Color-coding-fields

Background Shading

var text DateText = ToText([Delivery Date]);

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)