Hi,
I want to create a "stoplight" in my excel file where bubbles are conditionally formatted to be red, yellow, or green if their values are above, below, or equal to another cell that I reference. I know how to do conditional formatting, so I can easily do this with cells, but aesthetically I would like to have red, yellow, and green circles.
So far I've been inserting circles and hand filling them with colors. Is there a way to conditionally format pictures? Or is there a more automated approach to making circles appear certain colors depending on the relationship of their value compared to another cell?
Thanks for your help!
Lacey
I want to create a "stoplight" in my excel file where bubbles are conditionally formatted to be red, yellow, or green if their values are above, below, or equal to another cell that I reference. I know how to do conditional formatting, so I can easily do this with cells, but aesthetically I would like to have red, yellow, and green circles.
So far I've been inserting circles and hand filling them with colors. Is there a way to conditionally format pictures? Or is there a more automated approach to making circles appear certain colors depending on the relationship of their value compared to another cell?
Thanks for your help!
Lacey