Worksheet Layout

[da]

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

 

[Bernard Liengme]

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

 

[da]

Thank you, it worked.

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