Sheet1 Cell A1 has the correct data. Can Sheet2 Cell A1 be highlighted if its different to its Sheet1 counterpart?
Thank you.
Last edited by noellloyd; 11-22-2011 at 06:36 AM.
Yes, but only if you have it referring to a named range. If you have a large range of data, you could call the column on Sheet1 FirstSheet, and then for the conditional formatting formula in Sheet2!A1, you could have =A1=Index(FirstSheet,Row())
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
Hi, thanks for your reply. Would the same work for just one cell on one sheet?
Ive sorted it. Im using formula =IF(A1=Sheet1!A1,"","Error"). I then use Conditional Formatting to highlight a specific cell if it contains the words "ERROR".
Hi,
Im wanting a formula to check if "Sheet3!A!" is sequentional to the previous Sheet. This will repeat to check if "Sheet4!A1" is sequential to previous sheet. The problem is, with the exception of Sheet 1, the other sheets might not be included, so in my work book i might not use Sheet2, so thats why "Sheet3!A1" needs to be sequential to the previous sheet and not Sheet2.
I don't think this is possible without VBA. Unfortunately, I'm not skilled enough with VBA to help; however, there are others here who can, and probably do, write VBA in their sleep.
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks