This looks like it will work for me, need some things clarified, firstly I
want the specified row to change to the given back ground color when I update
the value of the progress indicator from 1-16 (each type of application has a
numerical value between 1 and 16 in my sheet) also I have specific colors for
each level 1 through 16, how do I find the correct number to specify the
color I want?

Thank you for your help.

(In addition since this is for work and the e-mail I specify for this is
home would you kindly send me a note to when you do
respond to this?)

Thank you again.
--
Judy Rose Cohen


"JE McGimpsey" wrote:

One way:

In Mike's code, instead of

Target.Interior.ColorIndex = x

use

Target.EntireRow.Interior.ColorIndex = x



In article ,
Chris Pederson wrote:

Hi Mike I'm having a simular problem but I need an entire Row to change
color to change as a result of the value of one cell is there way to do
this using this VBA?