How do I apply Conditional Formatting to a range?

[Chris]

I can apply Conditional Formatting to a single cell, e.g. E13, but how
do I apply the same CF to a range of cells, e.g. B13:E15, i.e. the CF
of all cells in the range is dependent on the condition being met in a
single specified cell in the range?

 

[Dave Peterson]

Select the whole range and apply the Conditional Formatting formula all at once.

If you always want to use A1 somewhere in your formula, make sure you enter that
address using $a$1. Just like a regular formula that's copied elsewhere, cells
with absolute addresses won't change.

 

[Chris]

Thanks Ron.
Like everything else its easy when you know how.

Try something like this:

If you want cells B13:E15 conditionally formatted based on the value in A1
being 10

Select B13:E15

From the Excel main menu:
<format><conditional formatting>
Click the first dropdown (that contains: cell value is)
and Select: Formula is
Set the next field to: =($A$1=10)
Click the [format] button and set your format
Click the O[OK] buttons and you're done.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

I can apply Conditional Formatting to a single cell, e.g. E13, but how
do I apply the same CF to a range of cells, e.g. B13:E15, i.e. the CF
of all cells in the range is dependent on the condition being met in a
single specified cell in the range?