Jan 04 2024 08:03 PM
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
Jan 04 2024 10:13 PM
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.
Jan 05 2024 07:32 AM