louie5117
01-29-2008, 02:19 AM
Hi everyone, new here as you will be able to tell from the content of the post that will follow.
Basically, I am at the moment doing a simple formula that returns a tick if a value is within a 5% tolerance margin of a certain value. In order to get a tick or cross returned I have used "Webdings 2" font on the particular cell and applied contional formatting so the tick returns green for a tick and red for a cross.
My problem is, if the value hasn't been populated (the figure isn't available) I have the formula returning "N/A".
As the cell is set to webdings 2, the random charecters show up rather than the desired text.
Is there any way of applying a code so that the font will change based on the returned cell value or text?
Hope you can help guys. Sorry if this has already been posted, I did a search!
Basically, I am at the moment doing a simple formula that returns a tick if a value is within a 5% tolerance margin of a certain value. In order to get a tick or cross returned I have used "Webdings 2" font on the particular cell and applied contional formatting so the tick returns green for a tick and red for a cross.
My problem is, if the value hasn't been populated (the figure isn't available) I have the formula returning "N/A".
As the cell is set to webdings 2, the random charecters show up rather than the desired text.
Is there any way of applying a code so that the font will change based on the returned cell value or text?
Hope you can help guys. Sorry if this has already been posted, I did a search!