+ Reply to Thread
Results 1 to 3 of 3

Question about having different conditional formatting in a column.

  1. #1
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    2007
    Posts
    314

    Question about having different conditional formatting in a column.

    For a given column within a table, can you set a particular conditional formatting for say row 1, then a different one for row 2, then a different one for row 3 where the following rows will automatically apply the formatting of row 3?

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,286

    Re: Question about having different conditional formatting in a column.

    Yes. Create the table, select the table column, apply the rule that you want to use for rows 3 and following.

    Then select the cell in row 1 and add a different rule.
    Then select the cell in row 2 and add a different rule.

    The column default will still be the rule that has been applied to the whole column, and the other two will be exceptions from that rule.

    The same principle applies to formulas, although it's a bit more complicated.

  3. #3
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    2007
    Posts
    314
    Quote Originally Posted by teylyn View Post
    Yes. Create the table, select the table column, apply the rule that you want to use for rows 3 and following.

    Then select the cell in row 1 and add a different rule.
    Then select the cell in row 2 and add a different rule.

    The column default will still be the rule that has been applied to the whole column, and the other two will be exceptions from that rule.

    The same principle applies to formulas, although it's a bit more complicated.

    Thank you. I suspected as much as I've noticed through experimentation what you're talking about with formulas. Thanks
    Excel 2010

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1