Hi randy

don't see why you need a macro ... and i can't see from your post what B10
has to do with anything, but here's a formula that checks the value of B8
and does the appropriate in N5
=IF(B8=0.35,"",IF(B80.35,"*","not sure"))
(also didn't know what you wanted to do if B8 was less than .35 ... replace
the "not sure" bit with what you want to see in N5 when B8 is less than .35)


Cheers
JulieD

"randy_tn" wrote in message
...

I need to compare the contents of (B:8) and (B:10) if the value of (B:8)
is .35 then do nothing but if it is greater than .35 I need to put an
"*" in (N:5).


Can somone PLEASE help me with this???



--
randy_tn
------------------------------------------------------------------------
randy_tn's Profile:
http://www.excelforum.com/member.php...o&userid=16001
View this thread: http://www.excelforum.com/showthread...hreadid=276411