try using the TRUNC function in your conditional formatting :
conditional formatting set to "Formula is" - enter
[COLOR=Blue=IF(TRUNC(A1)-A1=0,TRUE,FALSE)[/color] in the condition.
This returns FALSE if G7 is not an integer.
(not sure about your reference to Real Numbers (i.e. as opposed to
imaginary numbers))
Could also use INT in the same way if you prefer
--
optionbase1
------------------------------------------------------------------------
optionbase1's Profile:
http://www.excelforum.com/member.php...o&userid=25212
View this thread:
http://www.excelforum.com/showthread...hreadid=388903