How to highlight the ENTIRE row subject to a specific cell?

**sami770** · 06-01-2012, 08:01 AM

Hello everyone,
Can someone explain to me how to highlight the ENTIRE row subject to a specific cell?
Please see the excel file attached, as you can see, column D gets a specific color based on its value...
I would like the entire row to be highlight WITH THE SAME COLOR as in column D, for example - highlight entire row 2 with red, row 3 with orange and so on...

Thanks :-)

**Fotis1991** · 06-01-2012, 08:36 AM

Hi

You have to highlight all the rows, or thr range that you need and then in Conditional format rules, put the formulae.

1)$D2>90

2)=AND($D2>30;$D2<90)

3)AND($D2>1;$D2<30

Is this, works for you?

**sami770** · 06-01-2012, 08:44 AM

Thanks a lot Fotis1991
I need a macro based solution. Is it possible?

Originally Posted by Fotis1991

Hi

You have to highlight all the rows, or thr range that you need and then in Conditional format rules, put the formulae.

1)$D2>90

2)=AND($D2>30;$D2<90)

3)AND($D2>1;$D2<30

Is this, works for you?

**Fotis1991** · 06-01-2012, 08:51 AM

You are welcome.

As you need VBA(I can not understand why), i am not able to help you on this.

**arlu1201** · 06-01-2012, 09:39 AM

Actually you already have the rules set in your conditional formatting. You just have to change the applies to section to show columns A to D. Currently, it shows $D$2:$D$8. Just change it to $A$2:$D$8. Why do you want to do it via a macro?

**sami770** · 06-06-2012, 03:37 AM

thanks a lot for this

Originally Posted by arlu1201

Actually you already have the rules set in your conditional formatting. You just have to change the applies to section to show columns A to D. Currently, it shows $D$2:$D$8. Just change it to $A$2:$D$8. Why do you want to do it via a macro?