What I need to do (and I'm close to doing it) is I want to be able to enter
values in a cell but in the background (using a code module - VB) have those
values tested in a Value<cell value<value formula and then have the font
color change if the result is true.

so in other words

if (3.4<cell reference<13.9) then
sheet1.cell (2,2).font.color = rgb (255,0,0)
end if
end sub

Or something like this..

Right now the code only changes the font color regardless of the value
entered

thanks so much in advance

Jeff