Conditional Formatting across multiple columns and with a criteria

[techgirl]

Hello, I have a file that has a range for the current month with departments. In that range will have at least 4 columns with the last column a percentage. This is repeated multiple times in a worksheet for each month. So there may be 12 groups of this data on one worksheet. I want to set up conditional formatting for the entire worksheet; detect the percentage for each group on the sheet and apply color. BUT...there is a issue; within the list of departments; only dept 5 has its own criteria. Is the following possible??
1. all departments (Except dept 5) 75% and higher, format fill in green.
2. all departments (Except dept 5) 74% and lower, format fill in red.
3. Dept 5 - 25% and higher, format fill in green.
4. Dept 5 - 24% and lower, format fill in red.

January​
dept 1	11​	11​	100%​
dept 2	4​	4​	100%​
dept 3	16​	1​	6%​
dept 4	20​	12​	60%​
dept 5	5​	5​	100%​
dept 6	20​	10​	50%​

Thank you for your help.

 

[mart37]

You can use a formula like: AND ( col A <> dept 5 , col D >= 75% )

 

[techgirl]

Thank you, but that did not work. And if it would work, it will only work for that section; I needed something to do the entire worksheet.