Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Jan 05, 2024

Conditional formatting in Complex Conjugate

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,

Br,

Anupam

 

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor

    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.

Resources