| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Layout
Hi
If I want to highlight and change font color of text in every other row (from Row 1 to 200), is there an easy way to do it (aside from Autoformat)? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet Layout
Open Format | Conditional Formatting
Use Formula Is: =MOD(ROW(),2)=0 and click Format button, now set font colour Add another with Formula IS: =MOD(ROW(),2)= 1 and use a different font colour Need more? Try Google with search term: Excel conditional formatting If you are using XL 2007 use: Excel 2007 conditional formatting Here is a good site to start www.contextures.com/xlCondFormat01.html best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "da" wrote in message ... Hi If I want to highlight and change font color of text in every other row (from Row 1 to 200), is there an easy way to do it (aside from Autoformat)? thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet Layout
Format/ Conditional Formatting/ Formula Is:
=MOD(ROW(),2) if you want to format odd rows =MOD(ROW(),2)=0 if you want to format even rows. -- David Biddulph "da" wrote in message ... Hi If I want to highlight and change font color of text in every other row (from Row 1 to 200), is there an easy way to do it (aside from Autoformat)? thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet Layout
Thank you, it worked.
"Bernard Liengme" wrote: Open Format | Conditional Formatting Use Formula Is: =MOD(ROW(),2)=0 and click Format button, now set font colour Add another with Formula IS: =MOD(ROW(),2)= 1 and use a different font colour Need more? Try Google with search term: Excel conditional formatting If you are using XL 2007 use: Excel 2007 conditional formatting Here is a good site to start www.contextures.com/xlCondFormat01.html best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "da" wrote in message ... Hi If I want to highlight and change font color of text in every other row (from Row 1 to 200), is there an easy way to do it (aside from Autoformat)? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL 2007 WORKSHEET LAYOUT | Excel Worksheet Functions | |||
| EXCEL 2007 WORKSHEET LAYOUT | Excel Discussion (Misc queries) | |||
| Can I switch from Office 2007 layout to the old 2003 layout? | Excel Discussion (Misc queries) | |||
| Trouble with worksheet layout. | Excel Discussion (Misc queries) | |||
| How do I get/copy the (same) layout from a linked worksheet? | Excel Worksheet Functions | |||
Linear Mode
