Formula/Visual Response

[Mark]

I have a spreadsheet that totals up the deliveries we make to a customer and
subtracts the amount we sell on after. (ie they warehouse it for us)
I have a basic formula at the bottom of the sheet that subtracts sales from
deliveries to tell me if we are under or over sold. I want it to also show a
visual indicator so that if others use the sheet they know whether we can
deliver more or wait for more sales. Therefore I want the formula to also
show the thumbs up in green or thumbs down in red (using Wingdings letters C
& D) but this is dependant ion whether my original formula answer comes back
as negative or positive.

Any ideas?

Mark

 

[Gary''s Student]

Let's use A20 as an indicator of A10 in A20 enter:

=IF(A10>0,"C","D") and format as WingDings. Also format as Green.

Then click on A20 and:

Format > Condtional Formatting... > ValueIs > "D" and pick the Red font.