Conditional Printing

J

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
 
F

Frank Kabel

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

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.
 
G

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
 
A

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.
 
Top