Hi:
I would like highlight the lowest cell value on each of the rows. On the example below I would like to highlight the cell Items 1 - 46, Items 2 - 55, Item 5 - 42, Item 6 - 70.
Do I need to conditional format each row individually?
Easier solution?
Tks in advance
pll
This message was edited by plettieri on 2002-11-03 18:13
I would like highlight the lowest cell value on each of the rows. On the example below I would like to highlight the cell Items 1 - 46, Items 2 - 55, Item 5 - 42, Item 6 - 70.
Do I need to conditional format each row individually?
Easier solution?
MILLER21.XLS | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | |||
8 | No. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
9 | 1 | 70 | 84 | 86 | 85 | 84 | 72 | 100 | 85 | 66 | 46 | ||
10 | 2 | 100 | 82 | 74 | 55 | 68 | 82 | 100 | 88 | 92 | 82 | ||
11 | 3 | ||||||||||||
12 | |||||||||||||
13 | 5 | 100 | 80 | 75 | 48 | 44 | 66 | 100 | 91 | 70 | 42 | ||
14 | 6 | 100 | 84 | 78 | 70 | 76 | 74 | 100 | 97 | 82 | 84 | ||
1st qtr |
Tks in advance
pll
This message was edited by plettieri on 2002-11-03 18:13