if it is true then change the row color

**pedjvak** · 11-12-2012, 04:12 AM

hi every body
at first i would like to tanks from you and your very very good site then my problem is :
i have a table in excel wich filled by some data
I want if progress column is changed at below issue then chnged the color of same row for example:

for each i (i means number of row)
if cells(i,10)>0% then yellow color for row(i)
if cells(i,10)>40% then blue color for row(i)
and . . .
it means for each if in the cells(i , j ) we have diffrent color for same row(i)

thanks in advanced for your attention

**simeon.hruby** · 11-12-2012, 04:49 AM

pedjvack,

Do you have an example spreadsheet that I could look at?

Simeon

**sidd.iths** · 11-12-2012, 04:57 AM

hi,

why dont you use conditional formatting...

sid

**pedjvak** · 11-12-2012, 05:44 AM

I send my sample file , thanks for your attention

**sidd.iths** · 11-12-2012, 06:15 AM

hi,

try this

Please Login or Register  to view this content.

**pedjvak** · 11-12-2012, 06:34 AM

thanks for your answer
but
it is not work which i expected
it painted entire row but I want paint from a to f for each row like i painted in my sample manually
and the other problem is for each percent which i show you in my sample in column "e" i want give a diffrent color that show you in my sample file
your code act diffrent plz try by yourself maybe i am wrong

**sidd.iths** · 11-12-2012, 07:06 AM

oh, my bad,

try this:

Please Login or Register  to view this content.

**pedjvak** · 11-12-2012, 08:54 AM

thanks for your answer
it is complcate for me(V.B code) but it is working
I attached the file with some bugs which I try to show it to you when I run the code
it would be appreciated if you fix it