Conditional formatting based on two fields

[thecrowtv1]

So i have two fields I need to tie together for conditional formatting

If the "status" field says "RETURN" and its over "30" days then I need to highlight it RED

If the "status" field says "AVAILABLE" and its over "90" days then I need to highlight it RED

Is this possible?

 

[plog]

Yes. What have you tried?

https://support.office.microsoft.co...6db-bf23-3825676faf3d&ui=en-US&rs=en-US&ad=US

 

[thecrowtv1]

I also meant to say the field for days over 30 or 90 is the DaysLate field

Yeah I've tried the link above with no such luck.

 

[plog]

No, I didn't ask if you tried the link. I asked what have you tried and how it has not worked.

Asking if something is possible is too general of a question for us to provide specific advice in your instance. I need to know what you have done and how it has failed.

 

[thecrowtv1]

I tried this expression ([Status]=("Return")) & [DaysLate]>30

 

[plog]

Close. It should probably be this:

([Status]="Return") OR ([DaysLate]>30)

You had extra parenthesis around the string you were comparing, you need to use words to combine multiple conditions and you probably meant OR instead of AND, this way if either of the conditions are true it will apply the conditional formating.