Thread: Don't know if it's possible, but...
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default Don't know if it's possible, but...
On Tue, 28 Aug 2012 05:36:36 -0700 (PDT), wrote:

What I want to do is, if the user enters the value 'F' in any cell on the spreadsheet, I want that cell to display a character from the WingDings font--an arrow. If the enter the value 'B' in any cell, I want it to display another character from WingDings. I don't want it to display the WingDing equivalent of the 'F' or 'B', which is what I have at the moment.

Can anyone assist?

Duncan

Ordinarily, to change how a cell looks, you would use Conditional Formatting.

But I don't know how to do that as the font name is not a property of the conditional formatting object.

You could use an event macro which would actually change the value and formatting of the cell. That would destroy your original entry. Would that be acceptable?
Reply With QuoteReply With Quote