Auto Colors in Cells?

Learner7 · #1 07-04-2010, 09:18 AM

Hi,

I am using MS Excel 2007. I would like to know whether we can do the following:

If I write 2 in Cell A1, The Cells A2 & B2 to be automatically colored in red (as in the attached image file. If I increase the number in Cell A1 the A2 & B2.......etc. should be colored according to number written in the Cell A1.

Thanks.

ConneXionLost · #2 07-04-2010, 07:40 PM

Try this.

Cheers,

Learner7 · #3 07-04-2010, 09:43 PM

Quote:

Originally Posted by ConneXionLost

Try this.

Cheers,

Thanks. It doesn't change the cells color when I change the value in A1. Say, If I write 15 in Cell A1, it doesn't fill the below 15 cells with color. In the same way if I write 5 in Cell A1, it doesn't remove the color from extra 4 Cells.

Please make it clear.

Thanks.

ConneXionLost · #4 07-05-2010, 09:02 AM

Not sure why the first one didn't function as expected (posting issue?).

Here's a second attempt.

In case there's a problem here as well, then you may need to build it manually.

1. Select the entire second row of your sheet.

2. Got to "Conditional Formatting", and set "Formula is:

Code:

=$A$1>=COLUMN()

3. Select the red background colour, and click Okay.

Cheers,

Learner7 · #5 07-06-2010, 10:52 PM

Quote:

Originally Posted by ConneXionLost

Not sure why the first one didn't function as expected (posting issue?).

Here's a second attempt.

In case there's a problem here as well, then you may need to build it manually.

1. Select the entire second row of your sheet.

2. Got to "Conditional Formatting", and set "Formula is:

Code:

=$A$1>=COLUMN()

3. Select the red background colour, and click Okay.

Cheers,

Thanks. It is quite nice in your worksheet. But where can I write the formula in "Conditional Formatting" because there are several options. Which one is appropriate to write the above code? Please do further help.

Learner7 · #6 07-06-2010, 10:55 PM

Quote:

Originally Posted by Learner7

Thanks. It is quite nice in your worksheet. But where can I write the formula in "Conditional Formatting" because there are several options. Which one is appropriate to write the above code? Please do further help.

I got it. Thanks once again for the help.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
Underlining in black under different colors	87bob	Word	2	04-21-2010 03:37 PM
Chart colors change during slideshow	chickasaw	PowerPoint	0	02-06-2010 06:08 PM
Display the cells which add up to a certain sum	edbyford	Excel	1	11-26-2009 01:30 PM
Font colors	JerryB	Excel	1	11-30-2008 10:23 AM