conditional format

W

widman

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

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.
 
S

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
W

widman

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

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top