Hello,
I am trying to use conditional formatting to highlight cells in two rows that do not match. I am using the formula =$p2<>$q2
This formula works when I test it out by typing the values myself, but not when I paste the rows with the values. I have tried pasting only values, but that did not fix my issue either. I also do not see any difference in formatting etc.
Any help would be greatly appreciated.
Last edited by Johner10; 05-20-2020 at 11:09 AM.
Hi,
Go to conditional formating-Manage rule-look got " Applies to" and change the reang "$R$2:$S$7"
Hello Punnam,
Thank you for the quick reply, however, that did not work. It is also worth noting that I do not have the conditional formatting rule in the sheet attached that I have been using for columns p and q because it was not working.
Column P is text, whilst column Q is numeric. That's why it's not working.
Try
=value($P2)<>$Q2
Last edited by Fluff13; 05-18-2020 at 01:16 PM.
Hi Fluff13,
I tried it on the sheet provided by Johner but only one column is getting highlighted either column P or Colum Q.
Punnam
Oops, missed one of the $ signs, I've corrected the formula
hi Fluff13,
But some reason it's not working.
Punnam
Last edited by Punnam; 05-18-2020 at 01:27 PM.
That's not the formula I supplied.
Try this.
1 Select P2:P7.
2 Goto Conditional Formatting...
3 Select Use formula to determine which cells to format.
4 Enter this formula
=VALUE($P2)<>VALUE($Q2)
If posting code please use code tags, see here.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. As you are new, I have provided the link for you this time.)
https://www.mrexcel.com/board/thread...-work.1134470/
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you for the help! That almost works. It is highlighting ones that do not match, but it is also highlighting a lot that do. I wish I could show you the actual sheet I am dealing with, but it has thousands of rows and is too large to upload here.
I've no idea who you are referring to, but my suggestion works for me.
If it is not working for you, can you supply another sample book.
I can, but unfortunately I am new to this forum, and do not see how to attach a new spreadsheet. Would you mind enlightening me, please?
Never mind, I found it. It is the excel forum 2 doc.
Thanks for that. The problem is you have applied the CF to the entire column (not a good idea), in which case you need to use P1 & Q1 in the formula.
That seems to have worked! Thanks a lot, Fluff!!
You're welcome & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks