look under Format / Conditional Format. It will answer your question!
d

"JohnH" wrote:

I have been trying to set a range of cells Text colors based on the value in
the cell. I need the color to change as the data is being entered. When I
use the "Worksheet_Change(ByVal Target As Range)" function I cannot set a
specific range, any cell on the sheet changes when I enter data.

I would prefer not to loop through the range checking each cell since this
not only takes time, it is not immediate either.

Any help would be greatly appreciated.

John