G0 to the Help files, and lookup
Cell worksheet function
That will give you a list of the types of formats that can be returned.
Mostly date, time and currency formats.
The only color return would be the "negative red" in currency.
What you're looking for needs code.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
