Josh

See answer to your other post in excel.printing NG

Try to post in one group only. Most regulars monitor all Excel groups.

Gord

On Fri, 11 Jun 2004 15:46:36 -0700, "Josh Whitney" wrote:

Thanks Frank for your idea. In an attempt to make it simple, I probably
wasn't clear.


I am checking for the row number, if it is a multiple of 10, I want that row
to be highlighted.

Thanks again.

"Frank Kabel" wrote in message
...
Hi
try the following:
- select for example A1:F20
- goto 'Format - Conditional Format'
- enter the following formula
=$A1="X"
- choose your shading

--
Regards
Frank Kabel
Frankfurt, Germany


Josh Whitney wrote:
I want to shade columns B:F if the value in column A is ="X" for ease
in reading the print.

Any ideas?

TIA