Shading cells based on a value in another cell

**lucky_girl** · 02-26-2009, 04:44 PM

New to forum - I would like to shade a range of cells based on a value entered in another cell. For example if I enter "5", I would like to shade the next 5 cells in a row. I have tried conditional formatting, but have not been successful. Thank you in advance for your help!

**Ironman** · 02-26-2009, 05:43 PM

Hi

I've just did something similar but with bold and indents. I would assume that you could do the same by using offset(0,1)....here is a portion of my code (this looks in A2 and compares that value to H2)..if they are the same then it will indent the value in C2.

Please Login or Register  to view this content.

Hope that helps

**Ironman** · 02-26-2009, 06:29 PM

Hey L_girl - I took another look at put this quick VBA code together, I think this is a little more complete of an example. I'm not as good of a VBA'r as many of the folks on this forum, so if anyone has other suggestions for improving this code then by all means...I'm sure there is a much more effective way to do this but at the very least this should get you started....

Please Login or Register  to view this content.

Have a good day...

**VBA Noob** · 02-26-2009, 06:46 PM

Ironman,

Maybe

Please Login or Register  to view this content.

VBA Noob

**Ironman** · 02-26-2009, 06:54 PM

Short and sweet..nice

Tell me, what does

Please Login or Register  to view this content.

Do...?

**VBA Noob** · 02-26-2009, 06:59 PM

As the cell will have a value I use the resize method to resize the range to that number of cells. Search excel help or take a look at the below for more

http://msdn.microsoft.com/en-us/library/aa139976.aspx

VBA Noob

**Ironman** · 02-27-2009, 10:18 AM

A much better method...thanks for the input and the link, I've saved that link as it will be useful down the road...thanks again, enjoy your weekend...