I want to create a code that will cause the text in a cell to be form formatted a certain way if a number in an adjacent cell is greater than or equal to 2000. I need this to happen automatically behind the scenes.

IE:
Cell B1 = 2000 so cell A1 needs to automatically become bold and a different color
Cell B2 = 1999 so cell A2 has no change (normal text)

I know how to format the text but I'm not sure what the code is to point to the adjacent cell (noobish stuff, I know, but I'm still in the EARLY stages of learning VB and all on my own through trial and error and boards like this).

My document has 12 sheets (one for every month). I need a specific range in each sheet to be setup to be formatted in this way.

Thanks!