I am using an * for identification purposes, is there a way to highlight the
cell each time an * is entered?

Thank you for your assistance.

Select the range,do formatconditional formatting, cell value equal to
select pattern and colour and click OK twice

--


Regards,


Peo Sjoblom

"daynek" wrote in message
...
I am using an * for identification purposes, is there a way to highlight
the
cell each time an * is entered?

Thank you for your assistance.

Thanks for the reply, I am almost there with the instructions you provided,
but I don't quite have it. My spreadsheet has multiple cells with a date and
an asterisk*, example 2/2/08*, I need to highlight the existing cells with
dates and asterisks* as well as have the cell highlight automatically anytime
a date and asterisk* is entered.
"Peo Sjoblom" wrote:

Select the range,do formatconditional formatting, cell value equal to
select pattern and colour and click OK twice

--


Regards,


Peo Sjoblom

"daynek" wrote in message
...
I am using an * for identification purposes, is there a way to highlight
the
cell each time an * is entered?

Thank you for your assistance.

OK, try this. Instead of using cell value equal to, use formula is

Assume the range starts in A1 going to A100 (adapt accordingly to fit your
range of data)

Select A1:A100


formatconditional formattingformula is


=ISNUMBER(FIND("*",A1))


click the format button and select high light pattern colour and click OK
twice




--


Regards,


Peo Sjoblom

"daynek" wrote in message
...
Thanks for the reply, I am almost there with the instructions you
provided,
but I don't quite have it. My spreadsheet has multiple cells with a date
and
an asterisk*, example 2/2/08*, I need to highlight the existing cells with
dates and asterisks* as well as have the cell highlight automatically
anytime
a date and asterisk* is entered.
"Peo Sjoblom" wrote:

Select the range,do formatconditional formatting, cell value equal to
select pattern and colour and click OK twice

--


Regards,


Peo Sjoblom

"daynek" wrote in message
...
I am using an * for identification purposes, is there a way to highlight
the
cell each time an * is entered?

Thank you for your assistance.

Good Morning Peo;

Thank you very much, this worked.

"Peo Sjoblom" wrote:

OK, try this. Instead of using cell value equal to, use formula is

Assume the range starts in A1 going to A100 (adapt accordingly to fit your
range of data)

Select A1:A100


formatconditional formattingformula is


=ISNUMBER(FIND("*",A1))


click the format button and select high light pattern colour and click OK
twice




--


Regards,


Peo Sjoblom

"daynek" wrote in message
...
Thanks for the reply, I am almost there with the instructions you
provided,
but I don't quite have it. My spreadsheet has multiple cells with a date
and
an asterisk*, example 2/2/08*, I need to highlight the existing cells with
dates and asterisks* as well as have the cell highlight automatically
anytime
a date and asterisk* is entered.
"Peo Sjoblom" wrote:

Select the range,do formatconditional formatting, cell value equal to
select pattern and colour and click OK twice

--


Regards,


Peo Sjoblom

"daynek" wrote in message
...
I am using an * for identification purposes, is there a way to highlight
the
cell each time an * is entered?

Thank you for your assistance.