Looking for assistance for an unusual conditional formatting probl

J

John C.

There are two tables, say A1 through E5 and A7 through E11. I want to
compare A1 to A7 and color the minimum, compare A6 and A16 and color the
minimum, compare C1 to C7 and color the minimum, etc. I can figure out out
to write the first comparison, i.e.select A1 and A7, CONDITIONAL FORMATTING>
CELL Value equal to> =MAX(A$1,A$7), but how do I do the rest without
individually selecting A2 and A8 and doing the same thing, C1 and C7 and
doing the same thing, etc. Is there an elegant way to do this? And so I am
trying to compare apples to apples (cell to cell) in two tables. Any ideas?

Thanks for your consideration.

John
 
J

Jarek Kujawa

provided "compare A6 and A16" is a typo the following should work:

use =MAX(A1,A7)
then
1. copy A1
2. select A1:E5
3. PasteSpecial->Formats

repeat those steps for A7:E11

HIH
 
S

Stefi

Select A1:E5
CF>Formula: =A1=MIN(A1;A7)

Select A7:E11
CF>Formula: =A7=MIN(A1;A7)

Regards,
Stefi

„John C.†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top