Hi!


Conditional Formatting
Formula is: A1-INT(A1)=0

If the values will always be greater than or equal to 1, you could use:

=MOD(A1,1)=0

Biff

"excelgurudummy"
<excelgurudummy.1shqid_1121900760.7873@excelforu m-nospam.com wrote in
message news:excelgurudummy.1shqid_1121900760.7873@excelfo rum-nospam.com...

I have a spreadsheet that I want to highlight cell values that are whole
or real numbers - not decimals. I am having a heck of a time trying to
figure out the best way to do this. At this point, I really
don't care if they are highlighted or what, as long as the whole numbers
stand out somehow. The cells themselves contain a formula (i.e., B$1/A2)
So, if this formula results in a whole number (i.e., 1, 2, 3, 4 etc...)
not a decimal (i.e., 1.1, 1.2, 1.3, etc...) then I want it to stand
out.

I even tried nesting an "IF" function so that anything containing a
decimal would show the word "NO" instead of the value, but I couldn't
get it to work. Here's the formula I was trying, maybe someone can tell
me what I did wrong with it.

=IF(PRODUCT(B$1/A2),"*.*","NO",PRODUCT(B$1/A2))
I get an error that I'm using too many arguements.

Please help! Thank you in advance.
ExcelGuruDummy


--
excelgurudummy
------------------------------------------------------------------------
excelgurudummy's Profile:
http://www.excelforum.com/member.php...o&userid=25441
View this thread: http://www.excelforum.com/showthread...hreadid=388903