how to highlight odd numbered cells

[tessp727]

Version: 2004

How do I highlight only the odd numbered cells in an 800+ row document?

 

[Carl Witthoft]

Version: 2004

How do I highlight only the odd numbered cells in an 800+ row document?

you mean you want the odd-numbered rows highlighted?

Use Conditional Formatting, and select Formula,

and type in something like =IF(mod(row,2)=1,TRUE, FALSE)=TRUE
and then select the hilight color you want for the 'true' condition.