View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
david[_10_] david[_10_] is offline
external usenet poster
 
Posts: 2
Default 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