LinkBack URL
About LinkBacks
HI.
Can I use Conditional formatting (highlights duplicate values) but highlight the number even if the number is an Positive or Negative number.
It must highlight the number if it’s -300 or 300 in both instances.
Thank you
HI.
Can I use Conditional formatting (highlights duplicate values) but highlight the number even if the number is an Positive or Negative number.
It must highlight the number if it’s -300 or 300 in both instances.
Thank you
A possible workaround is to use a AbsoluteValues Column
and then auto-fill it.
=ABS(a2)
Conditional formatting will work on it.
Going to conditional Formatting> Use Formula
=AND(ISNUMBER(E3),SUMPRODUCT(--(ABS($E$3:$E$13)=ABS(E3)))>1)
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you so much that will work
what if I want to look at 3 column's at the same time?Originally Posted by ChemistB
Just modify the sumproduct to include the entire range
=AND(ISNUMBER(E3),SUMPRODUCT(--(ABS($E$3:$G$13)=ABS(E3)))>1)
Where E3 is the first cell in your range and G13 is the last cell in your range.
Awesome thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks