If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Looking for assistance for an unusual conditional formatting probl
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 |
#2
|
|||
|
|||
Looking for assistance for an unusual conditional formattingprobl
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 On 9 Lis, 05:15, John C. John wrote: 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 |
#3
|
|||
|
|||
Looking for assistance for an unusual conditional formatting probl
Select A1:E5
CFFormula: =A1=MIN(A1;A7) Select A7:E11 CFFormula: =A7=MIN(A1;A7) Regards, Stefi „John C.” ezt *rta: 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 |
Thread Tools | |
Display Modes | |
|
|