Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting
Using Conditional Formatting, how do I highlight cells that have integers &
those that have decimals? -- Dr. Sachin Wagh MBBS, DHA, DPH |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |