Conditional Formatting Rules from multiple columns based on conditions!!!

**vijay4b7** · 06-05-2014, 10:36 AM

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

**protonLeah** · 06-08-2014, 05:22 PM

To attach a Workbook
(please do not post pictures of worksheets)

Click Advanced (next to quick post),
Scroll down until you see "Manage Attachments",
Click that then select "add files" (top right corner).
Click "Select Files" find your file, click "open" click "upload"
Once the upload is completed the file name will appear below the input boxes in this window.
Click "Done" at bottom right to close the Attachment Manager.
Click "Submit Reply"

Post your workbooks directly to the forum.