Cell Shading
 

Can I use a logic function to select the highest value in a row or
column of values and then have it auotomatically shade that cell to
indentify it?

Cell Shading
 

Hi,
You can use conditional formating , and enter your formula there so when the
value is hit it will shade the cell

" wrote:

Can I use a logic function to select the highest value in a row or
column of values and then have it auotomatically shade that cell to
indentify it?

Cell Shading
 

Below is an example of my data . What I want to do is shade the
highest value in all columns except the last where I want to shade the
lowest. Excel 2007 I didn't see how to do that with conditional
formatting.

FG% FT% 3PTM PTS REB AST ST BLK TO
0.473 0.844 49 718 192 128 32 37 89
0.447 0.817 46 639 240 179 40 28 114
0.480 0.804 50 667 197 155 40 26 82
0.476 0.862 26 478 190 63 39 14 46
0.507 0.761 33 526 151 108 25 15 64
0.469 0.816 26 524 215 139 20 13 80
0.483 0.772 19 566 176 123 44 13 84
0.449 0.731 47 546 212 141 50 9 52
0.498 0.797 16 587 246 114 38 29 70
0.474 0.77 35 620 247 106 30 19 68




On Mon, 12 Jan 2009 08:01:03 -0800, Eduardo
wrote:

Hi,
You can use conditional formating , and enter your formula there so when the
value is hit it will shade the cell

" wrote:

Can I use a logic function to select the highest value in a row or
column of values and then have it auotomatically shade that cell to
indentify it?

Cell Shading
 

Thanks Eduardo I have come up with the right solution.

On Mon, 12 Jan 2009 08:01:03 -0800, Eduardo
wrote:

Hi,
You can use conditional formating , and enter your formula there so when the
value is hit it will shade the cell

" wrote:

Can I use a logic function to select the highest value in a row or
column of values and then have it auotomatically shade that cell to
indentify it?