B
Bradly
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.
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.