How do i auto fill cell color based on other cells' color?

**Kchatza** · 05-22-2012, 03:34 AM

Hello to everyone!

This is what i want to do.. Let's say there is table with columns A and B.

When i fill cell A2 with green color, i want cell B2 to auto fill with green color as well.. Is that possible? I think it requires VBA but i'm not a programmer..

So if you please help me, it's work related and it would help me a lot!!

Thank you very much!

(Excel 2007)

**Fotis1991** · 05-22-2012, 03:44 AM

Hi and welcome to the forum(Are you Greek?)

If you fill column A, under a condition, then you can use the same condition to fill column B and you do not need VBA.Just Conditional Formating.

Or else, you need.!

**Kchatza** · 05-22-2012, 04:11 AM

What i want to do is when i manually fill cell A2 with green color, that will automatically fill cell B2 with green color as well...

(Yes i'm greek! ;-) )

**Fotis1991** · 05-22-2012, 05:00 AM

I am not familiar with VBA but trying to help you, i found this.

Take a look there..

http://www.cpearson.com/excel/colors.aspx

Καλή σου μέρα(Have a nice day).