Newb diving into conditional formatting needs help.

I have two fields – “Date Received” & “Due By”

“Due by” is a calculation field -> Date Received + 21

I would like to use conditional formatting to change the color of the “Due By” field

Black for 21-15 days remaining

Blue for 14-8 days remaining

Orange for 7-1 days remaining

Red for 0 days remaining

I’ve been trying to come up with the correct calculation for Black only (baby steps) but I can’t figure it out.

Am I remotely close to being on the right path with this formula?

GetAsDate(Self - GetAsDate(Reviews::Date Received)) ≥ 15 and GetAsDate(Self - GetAsDate(Reviews::Date Received)) ≤21

Any advice?

Black for 21-15 days remaining

"remaining" as if counting from today? I don't see Get(CurrentDate) anywhere in your formula.

Hi Comment, thanks for responding.

I don't want it to count from today. I want it to count from the "Date Received" field.

IIUC, the count from "Date Received" is always 21.

Ugh....I'm glad it's Friday because i'm clearly burned out. Thanks for pointing that out. :doah: