Formula/Visual Response
 

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

Formula/Visual Response
 

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

=IF(A100,"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.
--
Gary''s Student - gsnu200848


"Mark" wrote:

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