| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I shade each alternate Excel row without selecting each?
I just want to shade every second row in a large spreadsheet to improve
readability but without invoking a full style. How can that be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I shade each alternate Excel row without selecting each?
On 21 Sep, 07:54, Ausi Drew <Ausi
wrote: I just want to shade every second row in a large spreadsheet to improve readability but without invoking a full style. How can that be done? Hi Assuming you haven't already applied any Conditional Formatting, then this would be one way to achieve this. The following applies to the steps to take in xl2003: 1. Select the used area in your worksheet (eg a1:Z100) and go FormatConditional Formatting 2. Change to Formula Is in the left hand side dropdown and type in the following formula: =MOD(ROW(),2)=1 and hit the Format button and apply the fill colour of your choice - this will colour odd rows the selected colour. Hope this helps! Richard |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I shade each alternate Excel row without selecting each?
Hi Drew,
Take a look here. http://xldynamic.com/source/xld.CF.html HTH Martin "Ausi Drew" <Ausi wrote in message ... I just want to shade every second row in a large spreadsheet to improve readability but without invoking a full style. How can that be done? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I shade each alternate Excel row without selecting eac
Richard ... a most excellent solution. Grateful thanks.
"RichardSchollar" wrote: On 21 Sep, 07:54, Ausi Drew <Ausi wrote: I just want to shade every second row in a large spreadsheet to improve readability but without invoking a full style. How can that be done? Hi Assuming you haven't already applied any Conditional Formatting, then this would be one way to achieve this. The following applies to the steps to take in xl2003: 1. Select the used area in your worksheet (eg a1:Z100) and go FormatConditional Formatting 2. Change to Formula Is in the left hand side dropdown and type in the following formula: =MOD(ROW(),2)=1 and hit the Format button and apply the fill colour of your choice - this will colour odd rows the selected colour. Hope this helps! Richard |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I shade each alternate Excel row without selecting eac
Thanks Martin ... excellent explanation. Most thankful.
"MartinW" wrote: Hi Drew, Take a look here. http://xldynamic.com/source/xld.CF.html HTH Martin "Ausi Drew" <Ausi wrote in message ... I just want to shade every second row in a large spreadsheet to improve readability but without invoking a full style. How can that be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change shade of cells when selecting multiple cells | Excel Discussion (Misc queries) | |||
| Selecting alternate cells | Excel Worksheet Functions | |||
| Selecting alternate rows | Excel Discussion (Misc queries) | |||
| Shade alternate lines | Excel Discussion (Misc queries) | |||
| How do I shade alternate rows in Excel 2002? | Excel Discussion (Misc queries) | |||
Linear Mode
