Click format in the menu and select CONDITIONAL FORMATTING.

Change the Condition 1 combo box to Formula Is and in the text box directly
to its right enter the following formula:

=MOD(A1,1)

Changing A1 to your starting cell.

Click the FORMAT command button and click the PATTERNS tab and select the
color of your choice and click the OK command button 2 times.
--
Kevin Backmann


"widman" wrote:

How can I change the format (color or background) of a cel when its formula
returns a decimal instead of a whole number?