Not entirely sure I follow but perhaps:
or![]()
=COUNTIF(A:A;-A1)
the above assume you want to highlight 10 if -10 appears elsewhere and vice versa![]()
=MATCH(-A1;A:A;0)
Not entirely sure I follow but perhaps:
or![]()
=COUNTIF(A:A;-A1)
the above assume you want to highlight 10 if -10 appears elsewhere and vice versa![]()
=MATCH(-A1;A:A;0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks