A andy_ May 24, 2006 #1 Is there any way of highlighling non whole numbers from a list, ie. an numbers with a decimal point, Thank
Is there any way of highlighling non whole numbers from a list, ie. an numbers with a decimal point, Thank
G Guest May 24, 2006 #2 Hi The usual way is to use =A2=INT(A2) which will return a TRUE if there is not decimal and a FALSE if there is. Hope this helps. Andy.
Hi The usual way is to use =A2=INT(A2) which will return a TRUE if there is not decimal and a FALSE if there is. Hope this helps. Andy.
R Ron Coderre May 24, 2006 #3 Andy_ Try this.... Select the range of values <edit><find> Find what: *.* Click the [Options] button Look in: Values Click the [Find All] button (That will DISPLAY a list of all matching cells...ONE of them will be selected) Press Ctrl+A (that will SELECT all of the matching cells) Does that help? Regards, Ron
Andy_ Try this.... Select the range of values <edit><find> Find what: *.* Click the [Options] button Look in: Values Click the [Find All] button (That will DISPLAY a list of all matching cells...ONE of them will be selected) Press Ctrl+A (that will SELECT all of the matching cells) Does that help? Regards, Ron
A aidan.heritage May 24, 2006 #4 You could also use the conditional formatting option to highlight the cells, using the a2=int(a2) suggestion already made.
You could also use the conditional formatting option to highlight the cells, using the a2=int(a2) suggestion already made.
