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

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?

Use Conditional formatting: Format Conditional fromatting, select "Formula
is" and enter the formula:

=AND(E1<"",E1=INT(E1))

and select the pattern colour that you want. Change the cell reference E1
to the cell that the conditional formatting is in.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"widman" wrote in message
...
How can I change the format (color or background) of a cel when its
formula
returns a decimal instead of a whole number?

thanks. worked great after I changed the , to a ; that I have to use because
of another software.

"Kevin B" wrote:

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?

Oops! worng way round. formula should be:

=AND(E1<"",E1<INT(E1))

But Kevin's formula is better.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
Use Conditional formatting: Format Conditional fromatting, select
"Formula is" and enter the formula:

=AND(E1<"",E1=INT(E1))

and select the pattern colour that you want. Change the cell reference E1
to the cell that the conditional formatting is in.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"widman" wrote in message
...
How can I change the format (color or background) of a cel when its
formula
returns a decimal instead of a whole number?