Link autofill in a cell to a dropdown box with conditional formatting for fill.

**maletvette** · 10-29-2017, 07:11 PM

Hi, I know how to link cell autofill using the view code function on virgin cells,

However, when I add the dropdown feature I can't get it to work. My problem is this:

When I dropdown a value in Colum "I", the data field will change color based on my selection.
What I need is for the corresponding row in clolum A and B to also change color with coloum I.

For instance:
I make a selection from the dropdown in I4 and it turns Red, I need colum A and B to also turn red (no current formatting on A and B).

Thanks for the help in advance.

I have Kutools, but not very good with it.

**teylyn** · 10-29-2017, 09:45 PM

Hello,

use a conditional formatting rule with a formula. Let that formula be

=$I4="something"

and let the format be red. With this formula you can apply the same rule to columns A and B, starting in row 4.

Note the $ sign in front of the column letter I. This will lock in the I as the column to look at, even when the rule is copied to another column. If you use the built-in rules that apply formats based on a cell's value, these will only look at the current cell.

cheers, teylyn

**maletvette** · 10-30-2017, 08:55 AM

Hi thanks for the reply,

I've tried this and it's not taking. I've also tried

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Me.Range("A2, B2").Interior.Color = Me.Range("I2").Interior.Color
End Sub

Nothing I try is linking the fill colors. =/

**teylyn** · 10-30-2017, 03:32 PM

Wait, you never mentioned VBA. You have posted in the formulas and functions forum. My reply is for Conditional Formatting, which will be faster than re-inventing the wheel with VBA.

"not taking" does not really help. Do you need help building the conditional format?

**teylyn** · 10-30-2017, 04:06 PM

Here's a screenshot and a sample file. If that does not do what you need, please describe in more detail what you want to achieve and post a data sample.
2017-10-31_8-39-19.png