Well, that is a bummer! It ought to be that easy! The rest of the formula is correct though! Thanks for the help!Welcome to the forum!
A formula just returns a value, it does not allow formatting. However you can use Conditional Formatting to do what you want. I think your formula is a bit off though. That will return the TRUE result if A6 is any non-zero number, as well as if A6=A5.