My interpretation is you want odd numbers highlighted, not odd rows.

Select the range of 2500 cells and FormatCellsCFFormula is:

=MOD($A1,2)=1


Gord Dibben MS Excel MVP

On Mon, 5 Nov 2007 08:56:02 -0800, Devin
wrote:

Is there a faster way to color format excel spreadsheets? I've got a
spreadsheet containing 2500 cells that must be formatted (highlighting every
odd number) and It's extremely tedious and time consuming to take every cell
and highlight it individually. Is there a faster way to do this?