In article ,
Stage Lamp wrote:

I redid your formula and tried again when i look at the formula results it
applied teh conditional format to 8-23-06 instead of the current day. I
copied your formula using cut and paste to make sure it was right. Maybe I
could figure this out if you could explain to me exactly what the formula is
doing step by step?

the only thing I can think of is that your computer's date is not set
correctly. Here's the breakdown:

=ROW()=TODAY()-DATE(YEAR(TODAY()),1,0)

1) ROW() returns the row number of the cell, e.g., for a cell on row 4,
it will return 4.

2) TODAY() returns the serial date, (e.g., 37534 for 6 Oct 2006, if
using the default MacXL 1904 date system).

3) YEAR(TODAY()) returns the year of the date (e.g., 2006)

4) DATE(2006, 1, 0) returns the serial date of the "zeroth" day of the
first month of 2006, which to XL is equivalent to the last day of the
previous month, or 31 Dec 2005 (i.e., 37255 if using the 1904 system).

5) Subtracting (4) from (2) returns the day of the year. That's 37534 -
37255 = 279 for 6 Oct 2006

6) Therefore ROW()=TODAY()-DATE(YEAR(TODAY()),1,0) will return TRUE for
a cell on row 279 (on 6 Oct 2006), and FALSE for cells on every other
row.

7) So row 279 should have the conditional format applied.