How about just using Conditional Formatting to put a cross-hatch pattern
behind the Y, or put a colored border around the cell, etc?

Vaya con Dios,
Chuck, CABGx3




"Jay" wrote:

Hi,

I'm trying to get a range of cells, in fact a column of cells, to be
formatted with a tick if the value contained within is Y. Unfortunately I
can't change the value to 0 or 1 and use simple custom formats as the the
information comes in from an xml file. This is further compounded by the
fact that I have some validation routines to check what has changed on a
reload of a similar xml file.

Hence, I need to find a way of formatting a cell so that it displays a tick
or nothing whilst maintaining the underlying string value Y or N. It seems
that I might have to write a function to interpret Y/N to 1 and 0 in any
case, followed by a custom format on the cells to display the appropriate
tick string. I'd rather not do this as I know it will give me a serious
performance hit on the xml upload routines.

I'm wondering if there is anyone there who can help me round this one.

Regards

Jason