Conditional formatting for rows?

[Guest]

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

 

[Bob Phillips]

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)

 

[Guest]

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

 

[Bob Phillips]

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


--
HTH

Bob Phillips

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

 

[Guest]

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