J
John
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.
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.