Brent

I suspect you were very close to the cure yourself. Try:

1) Highlight the area you wish to conditionally format
2) Format, conditional format, Formula Is
3) Enter =IF(B2="","",AND(B20,TODAY()<B$1))

If this doesn't work, study the conditional format formula in one of the
cells that is not giving the correct result. Take a close look at which row
and column you need to change to fixed reference to cure the problem.

HTH
Steve

"brentm" wrote in message
...
Hello all,

I have a formating issue, and I am not sure the best way to go about it.
I
have a spreadsheet that shows each day in a different column. I want any
projections (items in columns for days past the current or past days) to
have
the background highlighted yellow. I know how to use the conditional
format
in Excel, but there are so many cells, I have to adjust each one
individually. Is there a way maybe through Visual Basic that I can use to
"mass format" a specific area?

Here is what I have so far:

row 1 = column date headers ( B1 = 3/1/05, C1 = 3/2/05, D1 = 3/3/05, etc)

conditional formatting:

B2 =IF(B2="","",AND(B20,TODAY()<B1))
B3 =IF(B3="","",AND(B30,TODAY()<B1))
Etc down the row and across all columns.

Any help is appreciated!
BrentM