zest1
12-08-2005, 12:01 PM
Hi,
is possible to apply a common conditional formatting criteria to many separate data sets or groups, but for each group to use its own reference data that is part of that group? In other words, to have a list of many data sets, and each set having its own unique reference data as the comparative criteria, but applying the same conditional formatting to all the sets.
Example:
Ref1 contains the reference data for which to compare the data (A, B, C???) within that group to, and which to apply conditional formatting. Ref2 contains the second reference data to compare the data within that group to, the same for Ref3, and so on.
Ref1 298 | 130 | 163
A 9 | 228 | 384
B 172 | 90 | 12
C 41 | 312 | 149
D?
Ref2 213 | 37 | 263
A 59 | 228 | 84
B 172 | 90 | 151
C 41 | 312 | 89
D?
Ref3?
A
B
C
D...
Ref4?
?
So any data in groups falling within the range of the Ref data according to the conditional formatting criteia, will have that formatting applied, for example:
if the difference = 1 to 50, then Green;
else if the difference = 51-100, then Yellow;
else if the difference = 101-200, then Red;
else no color
Is there any way to do this, perhaps with a cell formula, lookup table, VBA, or ???
Thanks.
is possible to apply a common conditional formatting criteria to many separate data sets or groups, but for each group to use its own reference data that is part of that group? In other words, to have a list of many data sets, and each set having its own unique reference data as the comparative criteria, but applying the same conditional formatting to all the sets.
Example:
Ref1 contains the reference data for which to compare the data (A, B, C???) within that group to, and which to apply conditional formatting. Ref2 contains the second reference data to compare the data within that group to, the same for Ref3, and so on.
Ref1 298 | 130 | 163
A 9 | 228 | 384
B 172 | 90 | 12
C 41 | 312 | 149
D?
Ref2 213 | 37 | 263
A 59 | 228 | 84
B 172 | 90 | 151
C 41 | 312 | 89
D?
Ref3?
A
B
C
D...
Ref4?
?
So any data in groups falling within the range of the Ref data according to the conditional formatting criteia, will have that formatting applied, for example:
if the difference = 1 to 50, then Green;
else if the difference = 51-100, then Yellow;
else if the difference = 101-200, then Red;
else no color
Is there any way to do this, perhaps with a cell formula, lookup table, VBA, or ???
Thanks.