Excel formula to change another cell

**Dr4ke** · 05-06-2011, 05:15 AM

Good morning all,

I will try and explain exactly what I want and hopefully (!!) it will make sense. If you think you could help me; please reply

The situation is that I currently have around 20 columns of raw data, what I have to do on a daily basis is change columns A,B,C and D into a certain colour depending on the value of column U.

At the moment what I do is hide the columns in-between these 5 columns for easy reading, however would like a formula that I can put in conditional formatting (Perhaps an 'IF' or a 'VLOOKUP') to automatically change the different columns to the correct fill without all the manual work.

Any help would be appreciated, please let me know if any further explanation is needed.

Dr4ke

**Domski** · 05-06-2011, 05:39 AM

Hi,

First impression is this should be possible.

Could you upload a sample workbook showing the layout and the desired result and explain the conditions for each colour being applied?

Dom

**Dr4ke** · 05-06-2011, 06:07 AM

Originally Posted by Domski

Hi,

First impression is this should be possible.

Could you upload a sample workbook showing the layout and the desired result and explain the conditions for each colour being applied?

Dom

Hi Dom,

Firstly thank you for replying!

I have created a new example spreadsheet which should make things much easier to understand. In it I have included the following.

Data1, Data2, Data 3, Data 4 - These fields are the ones I will apply conditional formatting to.

N/A - These fields are irrelevant and can be ignored (they have only been added to show the full picture of the spreadsheet I am working on)

Result 1 - This field will determine the colour of the 'Data1', 'Data2', 'Data3', and 'Data4' columns. In this spreadsheet, what I would want is if the data in the 'Result 1' column is 'One' then I want the fill in 'Data1', 'Data2', 'Data3', and 'Data4' to change purple.

Hope this makes things clearer?

Dr4ke

**Domski** · 05-06-2011, 06:20 AM

To do that...

- Select A2:D25
- Go into conditional formatting
- Select Formula Is
- Enter formula: =$L2="One"
- Set your format

Example attached.

Dom

**Dr4ke** · 05-06-2011, 06:50 AM

Originally Posted by Domski

To do that...

- Select A2:D25
- Go into conditional formatting
- Select Formula Is
- Enter formula: =$L2="One"
- Set your format

Example attached.

Dom

Absolutely perfect!!!

I cannot thank you enough!

This is my first post on this site, so here comes to stupid question, can I rate you on your answer or anything like that?

Dr4ke

**Domski** · 05-06-2011, 07:09 AM

No problem, glad it helped.

There's a symbol that looks (a little) like a set of old style weighing scales in the heading of each reply. You can click on those to give 'rep' for a post if you choose to.

Take care,

Dom