Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula
Hi there
I'm looking for a formula that highlights numbers that have are not whole numbers. i.e. 1.02 I have a list of numbers, some whole numbers othere not. I'm using office '97 |
#2
|
|||
|
|||
Hi there,
Make use of Conditional Formatting. Select the cell(s) in question, I'll assume that A1 is the Activecell. (Note: This is HIGHLY important! The activecell can be checked by looking directly left of the formula bar; use this cell address in place of anything below!) Format (menu) | Conditional Formatting | Formula Is.. =A1< Int(A1) Format as desired. HTH, and regards, Zack Barresse "Jez" wrote in message ... Hi there I'm looking for a formula that highlights numbers that have are not whole numbers. i.e. 1.02 I have a list of numbers, some whole numbers othere not. I'm using office '97 |
#3
|
|||
|
|||
Thanks, for some reason I couldn't get it to work so I did it manually...
Jez "zackb" wrote: Hi there, Make use of Conditional Formatting. Select the cell(s) in question, I'll assume that A1 is the Activecell. (Note: This is HIGHLY important! The activecell can be checked by looking directly left of the formula bar; use this cell address in place of anything below!) Format (menu) | Conditional Formatting | Formula Is.. =A1< Int(A1) Format as desired. HTH, and regards, Zack Barresse "Jez" wrote in message ... Hi there I'm looking for a formula that highlights numbers that have are not whole numbers. i.e. 1.02 I have a list of numbers, some whole numbers othere not. I'm using office '97 |
#4
|
|||
|
|||
You can simplify that by using "Cell Value" and "Is not equal to" and =Int(A1)
"zackb" wrote: Hi there, Make use of Conditional Formatting. Select the cell(s) in question, I'll assume that A1 is the Activecell. (Note: This is HIGHLY important! The activecell can be checked by looking directly left of the formula bar; use this cell address in place of anything below!) Format (menu) | Conditional Formatting | Formula Is.. =A1< Int(A1) Format as desired. HTH, and regards, Zack Barresse "Jez" wrote in message ... Hi there I'm looking for a formula that highlights numbers that have are not whole numbers. i.e. 1.02 I have a list of numbers, some whole numbers othere not. I'm using office '97 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
Help with array formula | Excel Worksheet Functions | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions |