Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jul 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    57
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Hi,

    I have several spreadsheets where I need to change the background color of all rows where the text in column C of that row is "Total". I'm sure it's pretty straight forward with conditional formatting but I'm not that familiar with Excel 2007.

    Thanks,
    Sue

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Select the entire columns you want highlighted (eg A:G)
    Home tab, Conditional Formatting, New Rule...
    Select the 'Use a formula to determine which cells to format' option.
    Enter:
    =$C1="Total"
    as the formula and pick your formatting.
    Press OK.
    Done.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Star Lounger
    Join Date
    Jul 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    57
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Hi again... I have a 'To Do' spreadsheet and would like to change the background color of the rows (A1...E1) whenever a completion date is entered in E1.

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Same principle but different formula:
    =ISNUMBER($E1)
    (there is no IsDate function in Excel sadly).
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Star Lounger
    Join Date
    Jul 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    57
    Thanks
    4
    Thanked 0 Times in 0 Posts
    I figured it would be simple... wish I had more time to spend learning more about excel. Thanks for your help again.

Posting Permissions

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