+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : How to apply conditional formatting to cells based on their previous cell value.

  1. #1
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,629

    Smile How to apply conditional formatting to cells based on their previous cell value.

    Hi,
    I want to highlight all cells in a column based on their previous cell value.
    For example....
    In the column H, if h2<h1 or h3<h2 or h4<h3.....so on...they must be highlighted with red color indicating the lesser cell value than the previous one.

    I can format only one cell based on above condition but unable to do this with all the cells in that column with the above condition.

    Please help.

    Thanks
    Last edited by sktneer; 05-01-2011 at 10:29 AM.

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: How to apply conditional formatting to cells based on their previous cell value.

    Hi sktneer,

    Apply your conditional formatting to cell A2, ensuring you do NOT use absolute references.

    Then use the format paintbrush to copy the format down the remainder of the column.

    Cheers,
    Attached Files Attached Files
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,629

    Re: How to apply conditional formatting to cells based on their previous cell value.

    Hi ConneXionLost,
    Thanks for the help.
    It is working with some errors though your sheet is working fine.
    When I copy the format to other cells, the formatting is not working with some cells due to unknown reasons.

    Can you find the reason why is this happening ?
    Attached Files Attached Files

  4. #4
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: How to apply conditional formatting to cells based on their previous cell value.

    It seems you didn't take into account your column title ("Premium") when you followed the instructions. The result was setting each cell to change color if it was less than the cell above the previous cell; i.e., cell A10 is red because it is less than A8 (instead of A9).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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