+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : How do I apply the same Conditional Formatting to the next row?

  1. #1
    Registered User
    Join Date
    08-08-2008
    Location
    Johannesburg
    MS-Off Ver
    2007
    Posts
    55

    How do I apply the same Conditional Formatting to the next row?

    Hi Guys
    In cell "C2" I've created a Conditional Formatting based on B2.

    How do I apply the same rule to the next row?
    So, in "C3" I'll have the rule based on what happen in "B3".

    (I have more then 60 rows "C2:C66", and doing it manually makes me fall a sleep on my keyboard).

    Any suggestions?

    Thanks
    Last edited by furiousfox; 09-02-2009 at 07:47 AM.
    Using Excel 2007.
    Amit Cohen

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: How do I apply the same Conditional Formatting to the next row?

    Best to do all at once... highlight C2:C66 selecting C2 first then apply your formula just be sure to use appropriate absolute/relative references, eg:

    Please Login or Register  to view this content.
    the formula will be applied to the entire range relatively.

  3. #3
    Registered User
    Join Date
    08-08-2008
    Location
    Johannesburg
    MS-Off Ver
    2007
    Posts
    55

    Re: How do I apply the same Conditional Formatting to the next row?

    It is embarrassing how simple the solution is.

    Thanks so much for that!!

+ 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