Formula contrl of background color

[JAG-W]

I need to control the background colour of a cell from a formula there are between 7-10 colours to set, I don’t want to use VBA as I need the colour to update instantly. Any suggestions welcome.

JAG-W

 

[Von Pookie]

Not possible, to my knowledge. You can't even use conditional formatting since it only allows 3 separate conditions. You need a macro.

This comes up all the time. Search the board for "more than 3 conditions", to use one example. If you want the macro to run when the formula(s) recalculate, you need to use a Worksheet_Calculate event, not a Worksheet_Change as a lot of the search results may show.

 

[Von Pookie]

Hang on a minute.

http://www.mrexcel.com/board2/viewtopic.php?t=232362
Which is it? Just changing the background color, or dealing with graphics?

 

[Norie]

What makes you think VBA wouldn't change the background automatically?

 

[JAG-W]

If I could back up a little here this is a bolt on to a much bigger spreadsheet that will be able to print out a build plan showing colors and a number of graphics driven by a part number, my thinking was to drive the simple colour changes with a formula, and the graphics will be stacked bringing the selected on the front. My understanding is that the macros cant now be run from a formulae, and I really don’t want to have to trigger a macro button. If there is a way of automatically running a macro, then I think I have a solution but I cant find one. Any ides welcome

JAG-W

 

[Von Pookie]

From my (first) post yesterday:

This comes up all the time. Search the board for "more than 3 conditions", to use one example. If you want the macro to run when the formula(s) recalculate, you need to use a Worksheet_Calculate event, not a Worksheet_Change as a lot of the search results may show.

The macro won't run from the formula itself, however the sheet (re)calculation can trigger a Worksheet_Calculate macro to run.

Edit: There are other Event macros as well. Worksheets have Activate, Change and SelectionChange events, just to name a few (not to mention Workbook-level events as well). You should be able to find more info in the VBA help files and on the board.

Since you're working with graphics, I don't think I, personally would really be able to help with your specific issue. Many others around here more than likely can, though