Return Icons when positive or negative

I have budget worksheet with projected and actual cost. I want the items in the actual cost collumn to have icons next to them. A green icon if the value is less than the projected cost, and a red icon if the value is greater than the projected cost. I know how to do conditional formatting to display red/green text, however I want icons instead. I could manually go in and add icons, but I want it to change accordingly for each month when I have to add in the new month's actual costs.

Try it this way

if you are going to add the icons into a column
then you can use an if statement
to use green greater than 0 number
and yellow is less than 0
should mean red/green is only used
Now
in the cell you can use an if statement to -1 if value is less than projected
and 1 if above
what do you need for a 0?

your welcome, glad you have it resolved

if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved.