(2) Set conditional formats for the three possible cases:
=A1A2 | Font: Bold Red
=A1<A2 | Font: Bold Green
=A1 =A2 | Font: Normal White
I know this off topic but I read with interest on conditional
formatting. How do you go abouts setting the condtion? I went to
Edit-Go To-Special.
--
ernestgoh
------------------------------------------------------------------------
ernestgoh's Profile:
http://www.excelforum.com/member.php...o&userid=24870
View this thread:
http://www.excelforum.com/showthread...hreadid=384042