Conditional formatting in Complex Conjugate

Iron Contributor

Dear Experts,

                    Greetings and Wish you all a Very Happy New Year 🙂

I have an issue, where I need to apply conditional formatting to an Array , where one of the element is a "Complex conjugate" of another element, some highlighted as below :-

So, B1 is conjugate of A2, C2 is Conjugate of B3 and so on,

 

Could you please help me with a Formula in "Conditional Formatting" to get all the complex numbers with their corresponding conjugates in same color, as below:-

anupambit1797_0-1704427356307.png

Attached is the Worksheet,

 

Thanks in Advance,

Br,

Anupam

 

2 Replies

It seems they are just text (Excel treating them text values) and actually they are not same. So, it will really hard to compare each with other.

@ Peter Bartholomew

 as you have worked  a lot in this domain  , can you pls help Thanks!
 

 

Br,

Anupam