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

Any ideas?

TIA

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

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

Hi
see:
http://www.cpearson.com/excel/banding.htm

--
Regards
Frank Kabel
Frankfurt, Germany


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

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

Josh,

Here's what I do,

- select the used area and make sure A1 is the active cell
- in FormatConditional Formatting enter Formula is =MOD(ROW(A1),10)=0
- select format and it will be applied to every 10th row

HTH
Anders Silven

P.S. Just before sending this reply I see Gord Dibbens message that you have
posted the same question in another group. Please don't do that, you are wasting
peoples time.


"Josh Whitney" skrev i meddelandet
...
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