Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Josh Whitney - 11 Jun 2004 20:49 GMT

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

Any ideas?

TIA

Reply to this Message

Gord Dibben - 11 Jun 2004 22:41 GMT

Josh

Select the data range you want to format in columns B:F.

Format>Conditional Formatting>Formula is: =$A1="X"

Note the $ sign which makes this an Absolute Column/Relative Row reference.

Gord Dibben Excel MVP

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

Reply to this Message

Josh Whitney - 11 Jun 2004 23:48 GMT

Sorry Gord, I wasn't clear on the requirements.

If the row is evenly divisible by 10, I want to shade the row for clarity in
printing

Thanks

> Josh
>
[quoted text clipped - 12 lines]
> >
> >TIA

Reply to this Message

Gord Dibben - 12 Jun 2004 00:09 GMT

Josh

Assuming that "row is evenly divisible by 10" means the row number and not the
data value.......

Select Columns B:F and Format>CF>Formula is: =MOD(ROW(),10)=0

If you mean the data value in cells in Column A is divisible by 10.....

=MOD($A1,10)=0

Gord

>Sorry Gord, I wasn't clear on the requirements.
>
[quoted text clipped - 23 lines]
>> >
>> >TIA

Reply to this Message

Josh Whitney - 15 Jun 2004 21:25 GMT

Excellent! Thanks

> Josh
>
[quoted text clipped - 36 lines]
> >> >
> >> >TIA

Reply to this Message

Helen Tasky - 26 Jun 2004 03:50 GMT

FYI.. That isn't absolute column and row..it is only absolute row.

> Excellent! Thanks
>
[quoted text clipped - 44 lines]
> > >> >
> > >> >TIA

Reply to this Message