Can I use conditional formatting in such away that when data in Field 2 = D,
the cell in Field 1 must be date format, when Field 2=H, data in field 1 have
1 decimal point, all other values in Field 2 will set Field 1 to zero decimal
point?

Regards,
Mike