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

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

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

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