Forum Discussion
anupambit1797
Jan 05, 2024Iron Contributor
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
- anupambit1797Iron Contributor
- Harun24HRBronze 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.