New conditional formatting problem

Hi everyone. I recently got help here in solving a conditional formatting problem, and now I have a second, more complicated issue.

I've got a data sheet that has user activity over a period of months, measured week-by-week (with each column being a week, and each row a user). I've got conditional formatting going with this formula to call out users who stop using the site and which week they stopped coming back:

=AND(NOT(L1=0),N1=0,M1=0)

That works great. Now, I want to also find those users who meet the criteria of the above formula, but who have activity in some subsequent week. (My weeks go from M to AA). I'd like to have it so the cell that is initially colored red by the first formula is instead colored yellow if the person also meets the conditions of the second formula.

Any ideas?

Hi hmlee, could you post a sample workbook with your existing CF; and manually color new CF with some description?


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Here's a portion of my data. The red cells are formatted using CF, I've manually filled in some cells with yellow in the rows that fit. Ideally, I'd like it so that the red cells in those rows actually changed to yellow, but if necessary having it do what I've done manually, where the cell in the next column is yellow, would also work.

Base on your sample, select C2:Q27 and create new CF rules as follow:

Red: =AND(C2<>0,E2=0,D2=0)
Yellow: =AND(C2<>0,E2=0,D2=0,OR(F2:$Q2<>0))

ps: after saving your CF, yellow shall be the first rule and red on second rule (ordering is important for yellow to be on top of red when conditions met)


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

This seems to have worked! Thanks.

You're welcome, thanks for the feedback and reputation


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin