Conditional Printing

[Josh Whitney]

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

Any ideas?

TIA

 

[Frank Kabel]

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

 

[Josh Whitney]

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]

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

 

[Gord Dibben]

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

 

[Anders Silven]

Josh,

Here's what I do,

- select the used area and make sure A1 is the active cell
- in Format>Conditional 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.