Conditional formatting for rows?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FTM - 08 Nov 2006 12:17 GMT

I find conditional formatting very useful however I would like to be able to
highlight an entire row/range of cells if one cell has a given value, using
conditional formatting I am only able to highlight the single cell. Is it
possible to have a range/row of cells formatted in response to the value of
one cell?
Thanks

Reply to this Message

Bob Phillips - 08 Nov 2006 13:19 GMT

select the row and anchor the test cell in a formula such

=$A1=20

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> I find conditional formatting very useful however I would like to be able to
> highlight an entire row/range of cells if one cell has a given value, using
> conditional formatting I am only able to highlight the single cell. Is it
> possible to have a range/row of cells formatted in response to the value of
> one cell?
> Thanks

Reply to this Message

FTM - 08 Nov 2006 14:34 GMT

Hi Bob,
Thanks for responding unfortuantly I don't understand what you mean, can you
explain further?
Many thanks

> select the row and anchor the test cell in a formula such
>
[quoted text clipped - 9 lines]
> > one cell?
> > Thanks

Reply to this Message

Bob Phillips - 08 Nov 2006 15:02 GMT

Select say row 1
Menu Format>Conditional Formatting
Change Condition 1 to Formula Is
Add a formula of =$A1=20
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK
OK

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hi Bob,
> Thanks for responding unfortuantly I don't understand what you mean, can you
[quoted text clipped - 14 lines]
> > > one cell?
> > > Thanks

Reply to this Message

FTM - 08 Nov 2006 16:07 GMT

Hi Bob,
THANK YOU! You have no idea how long I have spent trying to to do this. This
really is fantastic.
Thanks again
F

> Select say row 1
> Menu Format>Conditional Formatting
[quoted text clipped - 28 lines]
> > > > one cell?
> > > > Thanks

Reply to this Message