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