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.
#2310136, By avtar *Official* Excel help thread
avtar 94 posts
Seen 1 year ago
Registered 13 years ago