Sorry I am sure this is here somewhere but I have not been able to find a post..

trying to do conditional formatting: stuck on the calculation to highlight if the date is GREATER than 80 days but LESS than 90 days

I want two conditional formats.

1. If it's more than 90 days since this field's date and (FIELD B ) is blank, highlight in RED. simple enough.

(Get(CurrentDate) - GetAsDate(Self)) > 90 and FIELD_B = ""

2. If it's equal or greater than 80 days but less than 90 days since this field's date, and (FIELD B ) is blank, highlight in BLUE. here is where I'm stuck.

thank you!

Well, since the field cannot be both blue and red at the same time, you can simply make the first condition:

Get ( CurrentDate ) - Self ≥ 80 and IsEmpty ( FIELD_B )