Auto Colors in Cells?

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.

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