More Than 3 Conditional Formating

[Michele]

I have a spreadsheet that I put to use and works brilliantly thanks to help I received here, Thank You, But now I find myself needing to add a condition but seem to be limited to only 3 conditions.

I have tried to use some code I found here but they are for specific values only and my need is much more simple in that I just want the row to change colors based on ANY value of 4 different cells. Doesn't matter WHAT is in these 4 cells, just as long as they are NOT EMPTY.

Here is my idea, I am using collumns A-U as my ROW. I want the ROW to be colored as listed below:

IF B1 = NOT EMPTY make row RED
IF H1 = NOT EMPTY make row YELLOW
IF N1 = NOT EMPTY make row GREEN
IF U1 = NOT EMPTY make row NO COLOR (white)

Letters, numbers and even zeros are ok, if ANYTHING is entered into the cell above, the row takes on the new color, overriding any previous colors.

So if B1 has a X in it and H1 has a X in it then the row will be YELLOW.
Likewise, wether there is nothing in cells B, H and N but IS a X in U1, the row should be NO COLOR.

Please let me know if I can provide more info, thank you, I will be standing by to answer questions,

M

 

[Michele]

Now I went and done it....

If I accidentally double click in a cell with text, that was a previous color, it doesn't realize the step ahead has been activated and reverts back to the previous color ??!! make sense ?

Lets say I have columns A,B,C,D and if I put any text in them, they should change color...and they DO. But if I have progressed through to step C and I accidentally double click in column B, which is step B, the row changes color to specifications in B, thinking that I wanted it to. Is there a way to make the row stay the color of the most recent step ?

say step/column ABC are filled in and I just double click or edit step/column A, if there is text in column B, C or D, the row should indicate the most recent step.

sorry, I have a headache now and thought I would give it to someone else...lol M