#2310136, By avtar *Official* Excel help thread

  • avtar 1 Jun 2007 11:30:16 94 posts
    Seen 1 year ago
    Registered 13 years ago
    If you only need to compare the new values with an original set of values you can make a copy of the sheet, then the use simple conditional like does not equal and compare to the cell in the copied sheet.

    If you remove the absolute references (the "$"'s ) you can use the format painter to copy the conditional over to the whole sheet and the compared to cell will adjust like it will when you fill down.
Log in or register to reply