Conditional Cell formating

[TJMorgan]

Hi. I am trying to set up the following formating:
Cell D6 (for example) will contain manually entered numbers between 1 and 1500 (grams). I am trying to get the adjacent cell, E6 to show a Wingding-type square or check box, if any figures appear in D6. No figures (even zero) in D6 - nothing showing in E6.

I am creating an interchangable gear listing from dropdown lists previously set up. The forum's help would be very much appreciated.

[Logit]

Format E6 as WindDings 2

Bold

Capital

Then paste this formula into the formula bar for E6:

=IF(D6<>"","R","")

[TJMorgan]

Thank you so much Logit. I tried the IF formating but couldn't get it to work - so close! Thanks again.

[Logit]

Yes, I first tried it with Conditional Formatting and finally realized selecting a particular font was not possible.

Had to use the formula bar and WindDings.