Calculation for greater than x but less than y

[sarahw]

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!

[comment]

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 )