Assuming that the dates are formatted as dates and the decimals are formatted
as numbers, then in the conditional formatting dialogue box, choose "cell
value is" and, in the window beside that option, enter the formula
=ISNUMBER(A1) where A1 is the cell to which you want to apply conditional
formatting. Select the formatting you want to apply for numbers.

For cells which are NOT numbers then, for the second condition, enter the
formula =NOT(ISNUMBER(A1) and select the formatting you want to apply for
not-numbers.

Dave
--
Brevity is the soul of wit.


"md" wrote:

I have a column that either draws from a column with a date or a column with
a number with 2 decimals. I want the fomatting to match whatever column it
ultimately pulls from. I can't seem to figure it out - the conditional
formatting feature only allows me to change the color and whatnot.