Formula to change a range of cell colours twice depending on 2 variables

**JayKay** · 02-26-2009, 07:24 AM

Hi everyone,

Firstly sorry for being probably rather naive with excel but I have a basic knowledge and have been asked to create a spreadsheet for work. Got the basics done but need to create some formulas so the colours change.

I basically need all the cells from A to F (need to go down infinitely) to start off red. Then when the cells from G to I are completed all the cells from A to I will turn orange then I have 5 more columns (J to N) that have yes and no data validation in them and when they are completed I want all the cells from A to N to automatically turn green. this is a continuous spreadsheet that will be used daily so the formula has to carry on downwards unlimited.

Sorry again for my lack of knowledge but when i learn something it stays in this head of mine so always happy to learn more.

If you have any questions just let me know.

Thanks in advance,

Jamie

**royUK** · 02-26-2009, 07:32 AM

You cannot change colours with formulas, you can use Conditional formatting

http://www.excel-it.com/excel_condit...formatting.htm

**JayKay** · 02-26-2009, 07:36 AM

Hi RoyUK,

Thanks for the quick and very helpful reply. I've been using that to change single cells but could not figure how to do it for multiple ones.

Will have a good read of that now.

Thanks again.

Jamie

**royUK** · 02-26-2009, 07:38 AM

post back for further help

**JayKay** · 02-26-2009, 10:33 AM

Hi,

Sorry to be a pain.

I have one column that we put a reference in that I want to make this change to orange when we enter text into it. The reference is normally 5-7 digits and consists of letters and numbers.

I have tried everything I can think of in conditional formatting and also googled it but can't find any help.

Thanks in advance.