How do I apply Conditional Formatting to a range?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 20 Dec 2006 14:04 GMT

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?

Reply to this Message

Dave Peterson - 20 Dec 2006 14:38 GMT

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.

> 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?

Signature

Dave Peterson

Reply to this Message

Rate this thread: