Conditional Format to Highlight Anything That is Not a Whole Number
I want to know if there is any way to highlight a cell that does not contain a whole number. In my spreadsheet I have a formula that calculates the number of packages in an order, but if the result is not a whole number then I want it to be highlighted. Can someone please help? Thanks!
Last edited by jlworden; 02-24-2014 at 05:05 PM.
Format with a formula
=MOD(A1, 1)<>0
Anything not evenly divisible by 1 (eg, not an integer) will trip the formula and format.
Give this a try:
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Use a formula to determine which cells to format
Assuming you have data in A5:
=(A5-INT(A5)<>0)
Then set your fill color, and then use the Format Painter to apply were needed
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Worked great, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks