Conditional formatting

[ra_weiss]

I have tried, to no avail, but is it possible to add conditional formatting which will replace any character entered in a cell with an "a"?

"a" because with marlett font that "a" becomes a checkmark.

I tried FORMAT:NUMBER:CUSTOM:"a", but that doesn't work.

 

[Damon Ostrander]

Hi ra_weiss,

Conditional formatting can't change the characters in a cell, but what you describe can be done using the Worksheet_Change event to replace the entered text with "a" in the cell or cells of interest.

Damon

 

[ra_weiss]

Hi ra_weiss,

Conditional formatting can't change the characters in a cell, but what you describe can be done using the Worksheet_Change event to replace the entered text with "a" in the cell or cells of interest.

Damon

Actually, regular formatting can. I resolved my issue by selecting marlett font and using a custom number of "a". Now, when a user puts a "1" in the cell it changes to a checkmark, and I've applied data validation to insure only a "1" will be accepted.