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:-


Attached is the Worksheet,


Thanks in Advance,




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!