IN THE ATTACHED FILE CONDITIONAL FORMATING WITH FORMUL IS APPLIED IN COLUMN A & B
WHEN I ENTERED SAME FIGURE IN COLUMN A & B THEN IT'S COLOUR BECOME RED
BUT WHEN I INSERT SAME FIGURE TWO TIME IN COLUMN A THAT'S ALSO BECOME RED
I DON'T WANT THAT , ONLY COMPARE FIGURE OF A COLUMN WITH B COLUMN
you can see example of value 544.3 in attached it means 544.3 in a column A become red only
one time
you should try below formula in conditional formatting rule.
Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
but i want that any same value anywhere in column A & any same value anywhere in column B
compare that values & show as duplicate , if value 615 in cell A59 & value 615 in cell B12 that value must be show as duplicate and become red
Last edited by keshavtale; 09-23-2017 at 04:53 AM.
Delete all the conditional formatting rule first then
Select column A and put conditional formatting rule =ISNUMBER(MATCH($A1,$B:$B,0))
Select column B and put conditional formatting rule =ISNUMBER(MATCH($B1,$A:$A,0))
Check the attached file.
thanks now my problem is solve
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
but one another problem is that formula only work when i enter any value manualy
if i copy paste that value then formula not work
Go to formula tab under calculation press on calculation option change into Automatic instead manual.
this is not different problem i saying that file that you send me for duplicate values (conditional formating)
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
as you can see in that file i only entered 618 manualy in that file so it is
become red but remaining values i copy paste from another file so it did not become red
for example 37944 that value i copy from another file so it did not become red
The numbers in A1:A17 are rational (have decimal components) while the numbers in B1:B13 are natural numbers. Try using the following modification of shukla's formula for the conditional formatting rule for column A:Formula:Please Login or Register to view this content.
Try using this modification of shukla's formula for the conditional formatting rule for column B:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
can you insert that formula in that file for me i could not understand how do that
Here is a copy of the file with the formulas applied.
Let us know if you have any questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks