Put a conditional format into a LastRow code

Hi there, if anyone can help.
Is there a way I can put a simple conditional format statement into a piece of LastRow code like

Please Login or Register  to view this content.

conditional format will be "IF N2 > P2 THEN = COLOUR YELLOW AND BOLD"

Or any other way of achieving the same?

Hello Paul,

This is written for Excel 2003. Not sure if this will work the same on later versions of Excel.

Please Login or Register  to view this content.

Leith, Thanks for your help so far but I haven't got it to work in 2007 yet but I will have a play around later as it is giving an object required error at

Please Login or Register  to view this content.

Update.
Leith, I had been trying to put it in a std module. Put it in a sheet module and is working correctly.
Thanks again

Hello Paul,

Glad you got it working. I assumed with 117 posts to your credit that including instructions on installing the macro wasn't needed. That's the trouble with assumptions.