Did you try filtering your data after entering the CF per Biff's instructions?


Gord

On Mon, 17 Mar 2008 21:16:01 -0700, STS wrote:

Thank you, it works.

"T. Valko" wrote:

Try this...

Assume the range of interest is A1:E5

Select the range A1:E5
Goto FormatConditional Formatting

Condition 1
Formula Is: =MOD(ROW(),2)0
Click the Format button
Select the Patterns tab
Select a gray fill
OK

Click the Add button

Condition 2
Formula Is: =MOD(ROW(),2)=0
Click the Format button
Select the Patterns tab
Select a blue fill
OK out

--
Biff
Microsoft Excel MVP


"STS" wrote in message
...
Hi,

How can I shade multiple rows at the same time, for example all odd row
numbers in gray, all even numbers in blue? I am sure there is a better way
of
doing it than manualy row by row. Thank you for your help.