View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
etks
 
Posts: n/a
Default Need help in conditional formatting


Appreciate if someone could help.
Column A and B comprises some percentages numbers. I wish to configure
column B such that if the values in column B is greater than A, change
the text to blue. if the value in column B is smaller than A, change
the text to red. As i have plenty of rows, it is tedious to do it cell
by cell for 300 plus rows. Thanks


--
etks
------------------------------------------------------------------------
etks's Profile: http://www.excelforum.com/member.php...fo&userid=6462
View this thread: http://www.excelforum.com/showthread...hreadid=500586