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

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

=$A1=20

--
HTH

Bob Phillips

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

"FTM" wrote in message
...
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

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

"Bob Phillips" wrote:

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

=$A1=20

--
HTH

Bob Phillips

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

"FTM" wrote in message
...
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

Select say row 1
Menu FormatConditional 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


--
HTH

Bob Phillips

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

"FTM" wrote in message
...
Hi Bob,
Thanks for responding unfortuantly I don't understand what you mean, can
you
explain further?
Many thanks

"Bob Phillips" wrote:

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

=$A1=20

--
HTH

Bob Phillips

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

"FTM" wrote in message
...
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

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

"Bob Phillips" wrote:


Select say row 1
Menu FormatConditional 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


--
HTH

Bob Phillips

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

"FTM" wrote in message
...
Hi Bob,
Thanks for responding unfortuantly I don't understand what you mean, can
you
explain further?
Many thanks

"Bob Phillips" wrote:

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

=$A1=20

--
HTH

Bob Phillips

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

"FTM" wrote in message
...
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