conditional format

[widman]

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

 

[Kevin B]

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.

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[widman]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk