Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Reston, Virginia, USA
    Thanked 0 Times in 0 Posts

    Cell function problem (Excel 2000 SR-1)

    I am trying to apply conditional formatting, in which the current cell turns red if the date in the same column, row 4 is prior to the current date.
    Putting the formula =ADDRESS(4,COLUMN(),2,1) into cell CD8 displays "CD$4", which is the address of the cell containing the desired date.
    Putting the formula =CELL("contents",CD$4) into a cell properly displays 34607 the date value of Sep 5, 2003.
    However, trying to substitute the cell address in the 2nd formula with the 1st formula to produce =CELL("contents",ADDRESS(4,COLUMN(),2,1)) produces an error report. What's wrong with this formula?
    My plan is see if the result of the above formula is < today(), which appears to work with the 2nd equation above. Do you see a better/simpler ways to create this conditional formatting definition?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Cell function problem (Excel 2000 SR-1)

    Select the range of cells you want to apply conditional formatting to. Say that the active cell in the selected range is in column CD
    Select Format | Conditional Formatting...
    Select Formula from the dropdown list.
    Enter =CD$4<TODAY() in the box next to the dropdown list.
    Specify the desired formatting.
    Click OK.

    That's it - if your selection contains multiple columns, the formula will adapt itself.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts