Conditional Formatting

[Josh Whitney]

something

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

Any ideas?

TIA

[Gord Dibben]

something

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

On Fri, 11 Jun 2004 12:49:24 -0700, "Josh Whitney" <barrowcl@flash.net> 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 Whitney]

something

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

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:5f9kc0tj6pfsamq2iifudj2m7brspo079g@4ax.com...
> 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
>
> On Fri, 11 Jun 2004 12:49:24 -0700, "Josh Whitney" <barrowcl@flash.net>
wrote:
>
>

[Gord Dibben]

something

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

On Fri, 11 Jun 2004 15:48:01 -0700, "Josh Whitney" <barrowcl@flash.net> wrote:

>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
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:5f9kc0tj6pfsamq2iifudj2m7brspo079g@4ax.com...
>reference.
>wrote:
>

[Josh Whitney]

something

Excellent! Thanks

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:6hekc05ppq8unjlqrc5o2diideu0j5btde@4ax.com...
> 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
>
> On Fri, 11 Jun 2004 15:48:01 -0700, "Josh Whitney" <barrowcl@flash.net>
wrote:
>
in[vbcol=seagreen]
in[vbcol=seagreen]
>

[Helen Tasky]

something

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


"Josh Whitney" <barrowcl@flash.net> wrote in message
news:%23FstZcxUEHA.1652@TK2MSFTNGP09.phx.gbl...
> Excellent! Thanks
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:6hekc05ppq8unjlqrc5o2diideu0j5btde@4ax.com...
not[vbcol=seagreen]
> the
> wrote:
clarity[vbcol=seagreen]
> in
<barrowcl@flash.net>[vbcol=seagreen]
ease[vbcol=seagreen]
> in
>
>