Change a cell's font color based on conditions

Hi -

Having trouble triggering a change in font color of a particular cell. See the attached worksheet and note the call procedure in the Sheet1 code window.

Whenever the values in cells B4 or B6 change, the value in cell B8 changes as well. What I need is to call a macro that will look at the value in B8,...whenever it changes..., and change the font color to either red or blue based on these conditions:

If cell B6 is < B4, turn B8 font to Red

If cell B6 is > B4, turn the cell font to Blue

First, I can' t figure out how to properly trigger my code to run. And secondly, the if statement in my code doesn't work either????? Here's my code so far:

Please Login or Register  to view this content.

How about

Please Login or Register  to view this content.