Coloring row

[Tiffany]

Hi

I have a spreadsheet that looks like that
Col A Col B Col C Col D Col E
brand A xxx xxx xxx xxx
brand B xxx xxx xxx xxx
band C xxx xxx xxx xxx

i used conditional formatting to automatically color brand A as red and
brand B as blue. The conditional formatting seems to able to color Col A. Is
it possible to extend the coloring from Col A to Col E, always referencing to
Col A. If not, any other alternatives.

Thank you in advance for your help.

[Bob Phillips]

You can select all the cells in the row and use a CF formula of

=$A2="brand A"



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tiffany" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> I have a spreadsheet that looks like that
> Col A Col B Col C Col D Col E
> brand A xxx xxx xxx xxx
> brand B xxx xxx xxx xxx
> band C xxx xxx xxx xxx
>
> i used conditional formatting to automatically color brand A as red and
> brand B as blue. The conditional formatting seems to able to color Col A.
Is
> it possible to extend the coloring from Col A to Col E, always referencing
to
> Col A. If not, any other alternatives.
>
> Thank you in advance for your help.
>
>

[Norman Jones]

Hi Tiffany,


> Is it possible to extend the coloring from Col A to Col E, always
> referencing to Col A.

Use the same CF condition for each cell in the row.

So, for example, in cells A1:E1, you might use the common condition:

=$A1<10

This anchors the coditional formatting for each cell in the A1:E1 range to
the value of A1.

You might wish to visit Debra Dalgleish's superb tutorial on Conditional
Formatting at:

http://www.contextures.com/xlCondFormat01.html


---
Regards,
Norman



"Tiffany" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> I have a spreadsheet that looks like that
> Col A Col B Col C Col D Col E
> brand A xxx xxx xxx xxx
> brand B xxx xxx xxx xxx
> band C xxx xxx xxx xxx
>
> i used conditional formatting to automatically color brand A as red and
> brand B as blue. The conditional formatting seems to able to color Col A.
> Is
> it possible to extend the coloring from Col A to Col E, always referencing
> to
> Col A. If not, any other alternatives.
>
> Thank you in advance for your help.
>
>