Double conditional formatting

[khansen]

Hello,

I would like to create a graphic in a small space. I would like to use a bar chart to display the magnitude of a measurement in one cell and the reading for that measurement (neighboring cell) would determine the color. For starters I could bin the measurements into 5 values to make life easier. It seems like the new conditional formatting in excel 2007 or 2010b would work well for this but I don't know how to conditionally format based on a neighboring cell or combine conditional formats.

Cheers!
Kirk