conditional formatting...

[Phillips]

I am wondering how I can format a cell based on if it has a DATE or a TIME
or a text string.

basically, if value is between 0 and 1, it is TIME if the value is strictly
number and greater than 1, it is a DATE otherwise, it is text.


Thanks,
Phil

 

[Chip Pearson]

Phil,

Try using a custom format of
[<1]hh:mm;mm/dd/yyyy


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com