mixed data

[Dohko]

Hi

I need some help with excel.
I have some data in column.
All the data is supposed to be numbers, however there is a possibility that some entries are strings.
for Example
Column A
1
1
2
4
test
t
6

What can I do to create a macro that will highlight the fields that have strings

Thanks for your help

[MSP77079]

Try this:

Please Login or Register  to view this content.

[Dohko]

Thanks
that works.
Can I do that for the whole spreadsheet?

[antoka05]

The macro MSP77079 can work for all sheet columns changing something:

Please Login or Register  to view this content.

Regards,
Antonio

[MSP77079]

Just to be different, here is another approach to the same result ...

Please Login or Register  to view this content.

An empty cell is considered numeric, by the way. But, a "blank space" in a cell is considered text.

[Dohko]

thanks for all the help-