I would like the cell to turn a highlight color if the result of a particular
formula is not a whole number.

Use this formula in your Conditional Formatting:

=MOD(A1,1)<0

Where cell A1 is the cell where your formula is located.

HTH,
Elkar


"danlinksman" wrote:

I would like the cell to turn a highlight color if the result of a particular
formula is not a whole number.

It does not appear to be working correctly. IF cell M-2 has a formula of
L2/I2 and the results are not a whole number I want the cell to flag itself
with a color. If it comes our as a whole number the cell color stays normal.
When I tested your formula the conditional formatting continued did not work
properly. I was wanting the cell to turn "yellow" when, for instance, a
number came out 1.25 instead of 1.0. IF the cell result was 1.0 the cell
would look normal. Any more ideas?

"Elkar" wrote:

Use this formula in your Conditional Formatting:

=MOD(A1,1)<0

Where cell A1 is the cell where your formula is located.

HTH,
Elkar


"danlinksman" wrote:

I would like the cell to turn a highlight color if the result of a particular
formula is not a whole number.

That formula should work for what you're describing. Let's make sure you've
got it set up properly. Follow these steps:

Select cell M2
From the Format Menu, choose "Conditional Formatting"
Change "Cell Value Is" to "Formula Is"
Enter the formula: =MOD(M2,1)<0
Click the "Format" Button and select a yellow background
Click OK
Click OK

That should work.


"danlinksman" wrote:

It does not appear to be working correctly. IF cell M-2 has a formula of
L2/I2 and the results are not a whole number I want the cell to flag itself
with a color. If it comes our as a whole number the cell color stays normal.
When I tested your formula the conditional formatting continued did not work
properly. I was wanting the cell to turn "yellow" when, for instance, a
number came out 1.25 instead of 1.0. IF the cell result was 1.0 the cell
would look normal. Any more ideas?

"Elkar" wrote:

Use this formula in your Conditional Formatting:

=MOD(A1,1)<0

Where cell A1 is the cell where your formula is located.

HTH,
Elkar


"danlinksman" wrote:

I would like the cell to turn a highlight color if the result of a particular
formula is not a whole number.

I set it up just as you showed. If my formula resides in cell M2 and cell L2
= 1.83 and cell I2 = 2 and I divide L2/I2 I do not come out with a whole
number in cell M2. The formula you suggested turns the cell yellow, however
if cell L2 =2 and I2 = 2 I come out with a whole number of 1 and the cell
still remains yellow.

"Elkar" wrote:

That formula should work for what you're describing. Let's make sure you've
got it set up properly. Follow these steps:

Select cell M2
From the Format Menu, choose "Conditional Formatting"
Change "Cell Value Is" to "Formula Is"
Enter the formula: =MOD(M2,1)<0
Click the "Format" Button and select a yellow background
Click OK
Click OK

That should work.


"danlinksman" wrote:

It does not appear to be working correctly. IF cell M-2 has a formula of
L2/I2 and the results are not a whole number I want the cell to flag itself
with a color. If it comes our as a whole number the cell color stays normal.
When I tested your formula the conditional formatting continued did not work
properly. I was wanting the cell to turn "yellow" when, for instance, a
number came out 1.25 instead of 1.0. IF the cell result was 1.0 the cell
would look normal. Any more ideas?

"Elkar" wrote:

Use this formula in your Conditional Formatting:

=MOD(A1,1)<0

Where cell A1 is the cell where your formula is located.

HTH,
Elkar


"danlinksman" wrote:

I would like the cell to turn a highlight color if the result of a particular
formula is not a whole number.

It works just fine for me. The only thing I can think of is that maybe
you've set the default background to yellow as well? Try chaning the cell
background to "No Fill" and then see what happens.

"danlinksman" wrote:

I set it up just as you showed. If my formula resides in cell M2 and cell L2
= 1.83 and cell I2 = 2 and I divide L2/I2 I do not come out with a whole
number in cell M2. The formula you suggested turns the cell yellow, however
if cell L2 =2 and I2 = 2 I come out with a whole number of 1 and the cell
still remains yellow.

"Elkar" wrote:

That formula should work for what you're describing. Let's make sure you've
got it set up properly. Follow these steps:

Select cell M2
From the Format Menu, choose "Conditional Formatting"
Change "Cell Value Is" to "Formula Is"
Enter the formula: =MOD(M2,1)<0
Click the "Format" Button and select a yellow background
Click OK
Click OK

That should work.


"danlinksman" wrote:

It does not appear to be working correctly. IF cell M-2 has a formula of
L2/I2 and the results are not a whole number I want the cell to flag itself
with a color. If it comes our as a whole number the cell color stays normal.
When I tested your formula the conditional formatting continued did not work
properly. I was wanting the cell to turn "yellow" when, for instance, a
number came out 1.25 instead of 1.0. IF the cell result was 1.0 the cell
would look normal. Any more ideas?

"Elkar" wrote:

Use this formula in your Conditional Formatting:

=MOD(A1,1)<0

Where cell A1 is the cell where your formula is located.

HTH,
Elkar


"danlinksman" wrote:

I would like the cell to turn a highlight color if the result of a particular
formula is not a whole number.

Do you have calculation set to Automatic or Manual?
Are the L2 and I2 values the number 2 typed into the cell, or is at least
one of them the result of a formula which isn't exactly 2?
--
David Biddulph

"danlinksman" wrote in message
...
I set it up just as you showed. If my formula resides in cell M2 and cell
L2
= 1.83 and cell I2 = 2 and I divide L2/I2 I do not come out with a whole
number in cell M2. The formula you suggested turns the cell yellow,
however
if cell L2 =2 and I2 = 2 I come out with a whole number of 1 and the cell
still remains yellow.

"Elkar" wrote:

That formula should work for what you're describing. Let's make sure
you've
got it set up properly. Follow these steps:

Select cell M2
From the Format Menu, choose "Conditional Formatting"
Change "Cell Value Is" to "Formula Is"
Enter the formula: =MOD(M2,1)<0
Click the "Format" Button and select a yellow background
Click OK
Click OK

That should work.


"danlinksman" wrote:

It does not appear to be working correctly. IF cell M-2 has a formula
of
L2/I2 and the results are not a whole number I want the cell to flag
itself
with a color. If it comes our as a whole number the cell color stays
normal.
When I tested your formula the conditional formatting continued did
not work
properly. I was wanting the cell to turn "yellow" when, for instance,
a
number came out 1.25 instead of 1.0. IF the cell result was 1.0 the
cell
would look normal. Any more ideas?

"Elkar" wrote:

Use this formula in your Conditional Formatting:

=MOD(A1,1)<0

Where cell A1 is the cell where your formula is located.

HTH,
Elkar


"danlinksman" wrote:

I would like the cell to turn a highlight color if the result of a
particular
formula is not a whole number.