Conditional Formating + Fonctions + Conditions

[jarnax]

Hello everybody !

I'm working in a Helpdesk and i have to show every monday a list of tickets still open.

All tickets are sorted by priorities and dates.

I've found a formula to change the font color in a row if a cell was equal to 0, 1 or 2

=INDIRECT("A"&ROW())=1 --> Orange
=INDIRECT("A"&ROW())=2 --> Red

It works great but i would like to improve the formula:

In my excell sheet, i created a column "Date". My boss asked me to put rows in red if an issue was open from more than 10 days in orange and between 10 and 20 days in red.

Is there a way to integrate this kind of conditions in my formula ?

Best regards,

Jarno

 

[jarnax]

Thanks jasonb75

It works now But (always a "but") it doesn't check the row "priority". I need this conditional formating only for priorities 1 and 2

 

[jasonb75]

Assuming no priority 0, add an extra condition to the formula.

=AND($D1 < 3;$A1 <= TODAY();$A1 >= TODAY()-10)
=AND($D1 < 3;$A1 < TODAY()-10;$A1 >= TODAY()-20)

otherwise

=AND(OR($D1=1;$D1=2);$A1 <= TODAY();$A1 >= TODAY()-10)

 

[jarnax]

thank you su much jason !

You made my boss happy !