View Single Post
  #10   Report Post  
ernestgoh
 
Posts: n/a
Default





(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