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