Thread: [Solved] Auto Colors in Cells?
View Single Post
 
Old 07-05-2010, 09:02 AM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline Windows XP Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

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
File Type: xls AutoColourCells2.xls (18.5 KB, 16 views)
Reply With Quote