Custom Conditional Formatting

[AmericanSeiko]

Hi all,

I was wondering whether it is possible to apply a color scale (red [low] - white - blue [high]) based on a nxn matrix to a different, distinct nxn matrix.

If its not possible, can anyone think of a clever way to do this? Right now I am defining 10 distinct custom rules, which apply the conditional formatting by checking whether the cells in the reference matrix fall within a fixed range.

For a simple example, if cell A1 is 0<x<1, format="" cell="" aa1="" red.="" if="" a1="" is="" -1="" <="" x="" blue.="" however,="" this="" approach="" not="" dynamic.="" any="" ideas?=""
< x <= 1, color cell AA1 red; if cell A1 is -1 < x <= 0, color cell AA2 blue.

Thanks!

- AS</x<1,>

 

[Special-K99]

For each colour you're going to need a CF rule.
You might be able to use MOD function and use the result to select different colours.

 

[AmericanSeiko]

What about something where i found the min and max of the reference matrix, and used the max - min as the scale to slide between two ends of an RGB triple? Is there a way to tell excel to color a cell with three RGB integers as an input?

 

[Special-K99]

Not sure about multi coloured cells, possibly using VBA, maybe someone else can confirm that.