Change image based on cell value

**Schneedrache** · 04-22-2011, 02:41 PM

I tried searching for this, but the search seems to be broken at the moment.

I'm trying to set up a metrics tracking sheet, and when a value changes I want the cell adjacent to it to change from a green dot, red dot, or yellow. I know that there is a rule that changes the cell the value is in, but I want the cell next door to change.

If anyone could point me in the correct direction I would be much obliged. Thanks!

**TMS** · 04-22-2011, 02:49 PM

You're talking about Conditional Formatting and you need to refer to a specific cell within the row. To do that, you need to make the column reference absolute and use a formula as the condition.

For example, if the cell that changes is in column B, use =$B2="... the value ..."

Probably easiest to post a sample workbook.

Regards

**Schneedrache** · 04-22-2011, 02:55 PM

I'm thinking That if I manually change the value from 100% to 60% the Green dot in the adjacent cell would change to Yellow.

Is that any clearer?

**TMS** · 04-22-2011, 03:02 PM

No, what you can see in front of you just isn't making it through the ether ;-) Sorry.

**Schneedrache** · 04-22-2011, 03:15 PM

Here is what I'm looking for. Thanks for any input.

**TMS** · 04-22-2011, 04:11 PM

I think you're going to need VBA for this. You've actually got two shapes in the cell, a circle and an arrow line.

You might want to rethink this.

Regards