S
Swish7
How can I format an excel worksheet to draw a border around a range of cells
that
a) contain a unique value in one column
b) only where a value in another column matches one of another group of
"valid" values.
For example, my source data is:
A B C D
2 UC 1 DD 0
3 UC 1 DD 0
4 UC 1 DD 1
6 UC 2 DD 1
7 UC 2 SDM 0
8 UC 2 MD 0
9 UC 2 DD 1
11 UC 3 DD 1
12 UC 3 SDR 0
13 UC 3 RD 0
14 UC 3 DD 1
I would like to draw a border around any unique UCs that also have either MD
or RD or SDR in column C.
In addition, I might like to highlight row 8 because it has MD in it. ..I
know how to do this on a single row. However, I don't know how to draw a
border around a range of cells.
In the example above, I want excel to draw a border around the range A7 to
D9 & another around A11 to D14.
Any help would be greatly appreciated.
Thank you,
that
a) contain a unique value in one column
b) only where a value in another column matches one of another group of
"valid" values.
For example, my source data is:
A B C D
2 UC 1 DD 0
3 UC 1 DD 0
4 UC 1 DD 1
6 UC 2 DD 1
7 UC 2 SDM 0
8 UC 2 MD 0
9 UC 2 DD 1
11 UC 3 DD 1
12 UC 3 SDR 0
13 UC 3 RD 0
14 UC 3 DD 1
I would like to draw a border around any unique UCs that also have either MD
or RD or SDR in column C.
In addition, I might like to highlight row 8 because it has MD in it. ..I
know how to do this on a single row. However, I don't know how to draw a
border around a range of cells.
In the example above, I want excel to draw a border around the range A7 to
D9 & another around A11 to D14.
Any help would be greatly appreciated.
Thank you,