Fast Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You can use conditional formatting to do this. Highlight all the data,
then Format | Conditional Formatting and select Formula Is rather than
Cell Value Is in the pop-up. Enter this formula:

=MOD(ROW(),2)=0

then click on the Format button, then the Patterns tab (for background
colour) and choose the colour you want. Click OK twice to exit.

You should find all your cells in even rows are now coloured. If you
want the odd rows coloured then you should change the 0 to 1 in the
formula.

Hope this helps.

Pete
 
Pete_UK's format solution will format odd rows, if you want to format cells
that have odd numbers use the following:

Select the cells to format and click FORMAT in the menu and select
CONDITIONAL FORMATTING.

Set condition 1 to FORMULA IS and enter the following formula:

=AND(ISNUMBER(A1),MOD(A1,2))

Then click the FORMAT command button and change the patterns or font color
to whatever it is you need to see.

The example formula above assumes that the selected data range starts at A1.
Change the cell address accordingly.
 
My interpretation is you want odd numbers highlighted, not odd rows.

Select the range of 2500 cells and Format>Cells>CF>Formula is:

=MOD($A1,2)=1


Gord Dibben MS Excel MVP
 
Back
Top