Short Macro Compile Error

[longgamma]

I am learning VBA for Excel and am amazingly stuck on something quite simple. Here is my macro (designed to simply bold numbers >5 and leave numbers <= 5 as regular font):

Please Login or Register  to view this content.

When I go to run this, I get an error that states Else Without If. I cannot for the life of me figure out what is wrong with the syntax. Additionally, even stranger, is that it will bold the numbers after numerous error messages.

[AB33]

Please Login or Register  to view this content.

[longgamma]

I got an error when I ran your code that says, "Object doesn't support this property or method."

[JosephP]

Please Login or Register  to view this content.

for the less than 5 numbers