Hi,

I need help with conditional formatting.
I searched many places and did not the one which I am looking for.

X72nZ.png

So, basically I have two columns. Column H (deals with severity (P1, P2, P3, P4)) and Column N (Number of days).

My condition should be like this..

If P1 then
No of days (3 conditions)
1. <10 (Green color)
2. >=10 (Orange)
3. >=20 (Red)
If P2 or P3 or P4 then
No of days (3 conditions)
1. <25 (Green color)
2. >=25 (Orange)
3. >=50 (Red)

I have filled it for one row (current selection) and I have to do it for all other columns (No of days, column).

=IF(OR($H$6="P2", $H$6="P3", $H$6="P4"), $N$6>=50)

=IF(OR($H$6="P2", $H$6="P3", $H$6="P4"), $N$6<25)

=IF(OR($H$6="P2", $H$6="P3", $H$6="P4"), $N$6>=25)

=IF($H$6="P1",$N$6>=20)

=IF($H$6="P1",$N$6<10)

=IF($H$6="P1",$N$6>=10)

Please let me the best way to get out of this!!!

Image [1]: http://i.stack.imgur.com/X72nZ.png