Formatting an object based on results of an equation

[Babilv]

Hi all,

I am trying to find a way to format the color of an object (auto shape) based on the results of an equation. Or based on the value in a cell.

I have racked my brain and just can't see how to do it. Any clues?

Thanks!

[Paul]

If you'd like the shape color to change based on the sheet's calculate event, you could use something like:

Please Login or Register  to view this content.

Otherwise, if you want to trigger the macro when a cell value is changed (whether it forces a recalculation or not) you could use the Worksheet's Change event:

Please Login or Register  to view this content.

You could even base the RGB color on the value of the cell with some modifications.