I have a spreadsheet that lists sales information for every day of the year:

Row 1 =January 1 data
Row 2 = January 2 data and so forth
Row 3 = January 3 Data and so forth

Is there a way to format the row so that when excel looks at the current
date it would highlight that days sales information all teh way across?

So if today was the 2nd of january, itwould highklight that row (Row 2) but
tommorrow on the 3rd it would highlight row 3 etc

One way:

Select rows 1:366. Choose Format/Conditional Formatting:

CF1: =ROW()=TODAY()-DATE(YEAR(TODAY()),1,0)
Format1: patterns/<your color


In article ,
Stage Lamp wrote:

I have a spreadsheet that lists sales information for every day of the year:

Row 1 =January 1 data
Row 2 = January 2 data and so forth
Row 3 = January 3 Data and so forth

Is there a way to format the row so that when excel looks at the current
date it would highlight that days sales information all teh way across?

So if today was the 2nd of january, itwould highklight that row (Row 2) but
tommorrow on the 3rd it would highlight row 3 etc

JE

I tried your formula but nothing happened. Does it make a difference how
that column is formatted? I have it formatted as a date with day of the week,
month,day,year

"JE McGimpsey" wrote:

One way:

Select rows 1:366. Choose Format/Conditional Formatting:

CF1: =ROW()=TODAY()-DATE(YEAR(TODAY()),1,0)
Format1: patterns/<your color


In article ,
Stage Lamp wrote:

I have a spreadsheet that lists sales information for every day of the year:

Row 1 =January 1 data
Row 2 = January 2 data and so forth
Row 3 = January 3 Data and so forth

Is there a way to format the row so that when excel looks at the current
date it would highlight that days sales information all teh way across?

So if today was the 2nd of january, itwould highklight that row (Row 2) but
tommorrow on the 3rd it would highlight row 3 etc

For me, Row 277 was formatted today. Your regular formatting doesn't
matter.

In article ,
Stage Lamp wrote:

I tried your formula but nothing happened. Does it make a difference how
that column is formatted? I have it formatted as a date with day of the week,
month,day,year

"JE McGimpsey" wrote:

One way:

Select rows 1:366. Choose Format/Conditional Formatting:

CF1: =ROW()=TODAY()-DATE(YEAR(TODAY()),1,0)
Format1: patterns/<your color

ok The first column is still listed as "a" does that make a difference?

or is there something subtle that I'm missing?

"JE McGimpsey" wrote:

For me, Row 277 was formatted today. Your regular formatting doesn't
matter.

In article ,
Stage Lamp wrote:

I tried your formula but nothing happened. Does it make a difference how
that column is formatted? I have it formatted as a date with day of the week,
month,day,year

"JE McGimpsey" wrote:

One way:

Select rows 1:366. Choose Format/Conditional Formatting:

CF1: =ROW()=TODAY()-DATE(YEAR(TODAY()),1,0)
Format1: patterns/<your color

I can't imagine what - using A1 or RC headers doesn't matter a bit to
the conditional format I provided.

Are you entering the formula in the conditional format dialog (i.e.,
Choose the Format/Conditional Format menu item, then choosing "Formula
is" from the dropdown, and entering the formula in the input box...)?

Are you selecting a format in the conditional format dialog?

In article ,
Stage Lamp wrote:

ok The first column is still listed as "a" does that make a difference?

or is there something subtle that I'm missing?