Colour x cells below it if data present

**bullchicken** · 01-23-2011, 05:00 PM

Hi,
I`m trying to work out how to have a the cell directly below a cell with data in it coloured and also a certain number of cells below.
So if there is something in B2, I want B2-B3 coloured, if there is something in E20, E21-26 need to be coloured.
The cells already have some conditional formatting on them for something else that cant be changed either, and needs to over-ride this. So if in the second example E23 has data, that cell cant be coloured but the 5 cells below that will be etc.
The number of cells to vertically be coloured will range from 1 to ~60

Have attached image of example, any help would be greatly appreciated.

**Leith Ross** · 01-23-2011, 05:32 PM

Hello bullchicken,

Welcome to the Forum!

In this instance, a picture is not worth a thousand words. You will get more responses to your post if you provide the workbook. This will also ensure you get the results you are looking for faster. .

**bullchicken** · 01-23-2011, 05:54 PM

Originally Posted by Leith Ross

Hello bullchicken,

Welcome to the Forum!

In this instance, a picture is not worth a thousand words. You will get more responses to your post if you provide the workbook. This will also ensure you get the results you are looking for faster. .

Sorry, I have attached a file I was going to test it out with. Not much in there really though.