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

    Tayler [the blue fox] :thanx:

  • 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.

    Tayler [the blue fox] :thanx:

  • 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

    Tayler [the blue fox] :thanx:

  • Re: Conditional Formatting: Greater Than 3 Conditions


    Hi


    post a copy of your spreadsheet, I am sure that Dave's suggestion can be adapted to your needs


    Robert

  • Re: Conditional Formatting: Greater Than 3 Conditions


    Quote from [the blue fox]

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

    Oh... :shocked: