Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Shading
Hi all,
I have a spreadsheet which is dynamic and I would like it to highlight the highest total in a row and then to colour it with the grey colour which I think is 15. How is this done? Thanks in advance Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Shading
Try Conditional Formatting:
1) Select the cells containing the totals 2) Select FormatConditional Formatting 3) From the dropdown list on the left select Formula Is 4) In the formula window paste the following formula. The formula assumes that the cell range containing the totals is A10:J10. Change to suit: "=A10=Max($A$10:$J$10)" 5) Click the Format button 6) Select the Patterns tab 7) Select the desired highlight colour Regards, Greg "Greg" wrote: Hi all, I have a spreadsheet which is dynamic and I would like it to highlight the highest total in a row and then to colour it with the grey colour which I think is 15. How is this done? Thanks in advance Greg |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Shading
one way.....
set a cell with the max value of the row eg =MAX(A1:IV1) then use conditional formatting for the row with the condition 'Cell Value is' 'Equal to' and the reference to the cell with the MAX formula in it Choose the color of the condition you require. -- Cheers Nigel "Greg" wrote in message ... Hi all, I have a spreadsheet which is dynamic and I would like it to highlight the highest total in a row and then to colour it with the grey colour which I think is 15. How is this done? Thanks in advance Greg |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Shading
Thanks Nigel will give it a go
Greg "Nigel" wrote in message ... one way..... set a cell with the max value of the row eg =MAX(A1:IV1) then use conditional formatting for the row with the condition 'Cell Value is' 'Equal to' and the reference to the cell with the MAX formula in it Choose the color of the condition you require. -- Cheers Nigel "Greg" wrote in message ... Hi all, I have a spreadsheet which is dynamic and I would like it to highlight the highest total in a row and then to colour it with the grey colour which I think is 15. How is this done? Thanks in advance Greg |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Shading
Hi
Greg Wilson's solution does it one! -- Cheers Nigel "Greg" wrote in message ... Thanks Nigel will give it a go Greg "Nigel" wrote in message ... one way..... set a cell with the max value of the row eg =MAX(A1:IV1) then use conditional formatting for the row with the condition 'Cell Value is' 'Equal to' and the reference to the cell with the MAX formula in it Choose the color of the condition you require. -- Cheers Nigel "Greg" wrote in message ... Hi all, I have a spreadsheet which is dynamic and I would like it to highlight the highest total in a row and then to colour it with the grey colour which I think is 15. How is this done? Thanks in advance Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop automatic cell shading | Excel Discussion (Misc queries) | |||
Automatic hi-lite or shading every other line | Excel Discussion (Misc queries) | |||
Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
Automatic shading of cells based on dates??? | Excel Worksheet Functions | |||
Automatic Shading of Cells | Excel Discussion (Misc queries) |