Conditional Formatting: Greater Than 3 Conditions

Hi Everyone ..

I have a cell that I want changed to green (red 133 Green 180 Blue 0) if a line is considered active. As conditional formatting only allows 3 arguments, I need to perhaps code it?

Along the columns are cells that can change a row to active or inactive.
Here are my arguments.

If B5>1 .. row = active
If B5>1 & G5>1 .. row = inactive
If B5>1 & G5>1 & H5>1 .. row = active

If at any time L5>1 & M5="" .. row = inactive .. OR
If at any time Q5>1 & R5="" .. row = inactive .. BUT

If at any time L5>1 & M5>1 .. or .. Q5>1 & R5>1 .. row = active

then ..

If H5>1, M5>1, R5>1, T5>1 & AH5="", AJ5="", AL5="" .. row = active

so If at any time AH5>1 .. or .. AJ5>1 .. or .. AL5>1 .. row = inactive

Hope this makes sense to someone.
More than happy to send a copy of the spreadsheet if it makes it any easier.

Tayler

Re: Conditional Formatting: Greater Than 3 Conditions

Hi ..

I have played with this coding .. but am not sure how this applies to what I am trying to do.

I do not need multiple colours nor multiple aruguments as shown in the coding. So I have removed the multiple colour lines, now I get B5:B254 to equal a green cell if the cell = 1 to 999999, though now how do i continue to change B5 to normal colour and back to green depending on what is put into the other columns?

Maybe I am not understanding how this code applies to my request.

I only want the cell B5 to change to one single colour based on those other columns have a value greater than 1.

Re: Conditional Formatting: Greater Than 3 Conditions

no .. the red blue green I gave in my original message is the colour scale that makes up the shade of green I want