tyson
CF will allow up to 4 formats per cell, including the default format.
However, CF will not place number values in cells.
Can format only as in Fonts, Borders and Patterns.
What would you like to have done?
Perhaps there is another method.
A worksheet function such as one of the LOOKUP functions or MATCH.
Gord Dibben Excel MVP
