Value based Text Colors
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
|