Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Nov 2005
    Location
    Monkton, Maryland, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional formatting (Excel 2003)

    I have a spreadsheet for clients. This sheet has a column for the open date and one for the close date. I want to have it set up such that when I enter a date in the Closed column the entrie ROW will change color so that when I open it I can readily see which cases are closed. I have formatted it so that the cell in that column changes color but I want the entire row to change color. Any help would be appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional formatting (Excel 2003)

    Select the rows you want to format (or the entire sheet).
    Select Format | Conditional Formatting...
    Select Formula Is from the first dropdown list.
    Enter a formula like the following in the box next to it:
    <code>
    =$C2<>""
    </code>
    where C is the column for the close date, and 2 is the row of the active cell within the selection. The $ before the C means that C is fixed. The absence of a $ before the 2 means that it will automatically be adjusted for the other rows in the selection.
    Click Format... and set the formatting you want.
    Click OK twice.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2005
    Location
    Monkton, Maryland, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting (Excel 2003)

    Hi Hans. Thanks for your quick response. I will admit that I am not a seasoned Excel user. I have followed your directions (I think). The column where I will be putting the closed date is G. So this is what I did. CTRL + A, Format | Conditional Formatting | Formula Is | =$G2<>"". But it is not changing the color of all of the instances where there is a date in that column. What am I doing incorreclty?

  4. #4
    2 Star Lounger
    Join Date
    Nov 2005
    Location
    Monkton, Maryland, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting (Excel 2003)

    Hi Hans:

    I must have had a type. I redid it and it's working great! Thanks for all your help and patience!

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional formatting (Excel 2003)

    The 2 in the formula represents the row number of the active cell. Look at the box on the left hand side of the formula bar. If it says A1, you should use 1 as row number:

    =$G1<>""

    and if it says H37, you should use

    =$G37<>""

Posting Permissions

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