format cells from data range
 

I am trying to conditionally format a range of cells based on data entered
into a separate range of cells. The first range is 6 cells wide and 100 rows
long. The second range to match to is 7 cells wides and 100 rows long. If a
number in the first range matches ANY cell in the second range, the format
needs to be changed.

Conditional Formatting won't permit selection from a range.

format cells from data range
 

You're going to have to do this with a Worksheet_Change event. Here's some
more information.

http://www.mvps.org/dmcritchie/excel/event.htm
--
HTH,
Barb Reinhardt



"John" wrote:

I am trying to conditionally format a range of cells based on data entered
into a separate range of cells. The first range is 6 cells wide and 100 rows
long. The second range to match to is 7 cells wides and 100 rows long. If a
number in the first range matches ANY cell in the second range, the format
needs to be changed.

Conditional Formatting won't permit selection from a range.