Conditional formatting for rows?
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
|