Auto Colors in Cells?

		Microsoft Office Forums > Microsoft Excel > Excel
Auto Colors in Cells?

FAQ

Thread Tools

Display Modes

07-05-2010, 09:02 AM

ConneXionLost ConneXionLost is offline

Windows XP Auto Colors in Cells?

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

ConneXionLost is on a distinguished road

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,

Attached Files

AutoColourCells2.xls (18.5 KB, 18 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:24 PM.