Conditional Formatting
 

Using Conditional Formatting, how do I highlight cells that have integers &
those that have decimals?
--
Dr. Sachin Wagh
MBBS, DHA, DPH

Select the cells that you want to format
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the formula box, enter a formula that refers to the active cell:
=B2/INT(B2)=1
Click the Format button
Select the formatting you want for integers, click OK

Click Add
From the first dropdown, choose Formula Is
In the formula box, enter a formula that refers to the active cell:
=B2/INT(B2)<1
Click the Format button
Select the formatting you want for integers, click OK, click OK

Note: numbers with .0 will be highlighted as integers

Dr. Sachin Wagh wrote:
Using Conditional Formatting, how do I highlight cells that have integers &
those that have decimals?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Or maybe a formula like:

=(b2=int(b2))
or
=(b2<int(b2))

Bad things may happen when Int(b2) = 0.


Debra Dalgleish wrote:

Select the cells that you want to format
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the formula box, enter a formula that refers to the active cell:
=B2/INT(B2)=1
Click the Format button
Select the formatting you want for integers, click OK

Click Add
From the first dropdown, choose Formula Is
In the formula box, enter a formula that refers to the active cell:
=B2/INT(B2)<1
Click the Format button
Select the formatting you want for integers, click OK, click OK

Note: numbers with .0 will be highlighted as integers

Dr. Sachin Wagh wrote:
Using Conditional Formatting, how do I highlight cells that have integers &
those that have decimals?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

--

Dave Peterson

Thanks -- that's much better.

Dave Peterson wrote:
Or maybe a formula like:

=(b2=int(b2))
or
=(b2<int(b2))

Bad things may happen when Int(b2) = 0.


Debra Dalgleish wrote:

Select the cells that you want to format
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the formula box, enter a formula that refers to the active cell:
=B2/INT(B2)=1
Click the Format button
Select the formatting you want for integers, click OK

Click Add
From the first dropdown, choose Formula Is
In the formula box, enter a formula that refers to the active cell:
=B2/INT(B2)<1
Click the Format button
Select the formatting you want for integers, click OK, click OK

Note: numbers with .0 will be highlighted as integers

Dr. Sachin Wagh wrote:

Using Conditional Formatting, how do I highlight cells that have integers &
those that have decimals?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanx a ton!
that's made life much easier for me!

"Debra Dalgleish" wrote:

Thanks -- that's much better.

Dave Peterson wrote:
Or maybe a formula like:

=(b2=int(b2))
or
=(b2<int(b2))

Bad things may happen when Int(b2) = 0.


Debra Dalgleish wrote:

Select the cells that you want to format
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the formula box, enter a formula that refers to the active cell:
=B2/INT(B2)=1
Click the Format button
Select the formatting you want for integers, click OK

Click Add
From the first dropdown, choose Formula Is
In the formula box, enter a formula that refers to the active cell:
=B2/INT(B2)<1
Click the Format button
Select the formatting you want for integers, click OK, click OK

Note: numbers with .0 will be highlighted as integers

Dr. Sachin Wagh wrote:

Using Conditional Formatting, how do I highlight cells that have integers &
those that have decimals?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html