Insert Object when condition met

  • Thread starter Thread starter Eileen
  • Start date Start date
E

Eileen

I would like to insert drawing objects depending on what
value is in a cell.
eg
if A3 = 1000 then paste a gold star in B3
if A3 = 2000 then paste a red dot in B3
etc
Any ideas?
 
You can do this with a formula and conditional formatting:

Format cell B3 with Font Wingdings
In cell B3, enter the formula:
=IF(A3=1000,CHAR(171),IF(A3=2000,CHAR(108),""))
With cell B3 selected, choose Format>Conditional Formatting
From the first dropdown, choose 'Cell Value Is'
From the next dropdown, choose 'equal to'
Click in the text box
Hold the Alt key, and on the number keypad, type 0171
Click the Format button, and choose a gold colour
Click OK
Click the Add button
From the first dropdown, choose 'Cell Value Is'
From the next dropdown, choose 'equal to'
Click in the text box
Hold the Alt key, and on the number keypad, type 0108
Click the Format button, and choose a red colour
Click OK, click OK
 
Back
Top