I have a very large list of cases. I have put codes in columns N and O to
determine if the cases need to be listed in a separate list. For example,
the main list is of F cases. If the client also has an A case, a "1" or "2"
is placed in column N, and if there is a "T" case, a "1" or "2" is placed in
column O.

Is there a way to use conditional formatting so that if the cell in either
column N or O contains a "1" or a "2", all of the other cells in the row
(A:M) will be formatted a certain way (for example, all cells colored red or
the font changed to white, etc.)?

Also, is there any way in Visual Basic to cut the formatted rows and paste
them in separate worksheets? For example, if row 36 also has an "A" case,
can it be formatted, then actually cut and pasted in another worksheet
entitled "A Cases", and likewise for other rows that have "A" or "T" cases?

Thanks.

I can help with the c/f aspect. I'm assuming 2007.

If data is in row 1

Highlight a1:m1
Home tab - cond formatting
New rule
Use formula to determine which cells to format
Input =N1=1
format
fill red and font white
Ok

That's a simple way to get the row to perform as you want it when N1 has 1.
I don't know how to get the one formula to accept 1 & 2 for each cell but if
nobody comes up with it you can do as I did and simply format each of the two
cells twice as required.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Bradly" wrote:

I have a very large list of cases. I have put codes in columns N and O to
determine if the cases need to be listed in a separate list. For example,
the main list is of F cases. If the client also has an A case, a "1" or "2"
is placed in column N, and if there is a "T" case, a "1" or "2" is placed in
column O.

Is there a way to use conditional formatting so that if the cell in either
column N or O contains a "1" or a "2", all of the other cells in the row
(A:M) will be formatted a certain way (for example, all cells colored red or
the font changed to white, etc.)?

Also, is there any way in Visual Basic to cut the formatted rows and paste
them in separate worksheets? For example, if row 36 also has an "A" case,
can it be formatted, then actually cut and pasted in another worksheet
entitled "A Cases", and likewise for other rows that have "A" or "T" cases?

Thanks.