I need to find the format type of a cell in excel. I have an IF statement
that will take a numeric number and apply it to a range to see if it falls
into the range or outside of the range but when the cell has a text value it
bombs on me.

I need to validate which format it has before I apply the condition.

Thanks for you help,

-Chris