Conditional format your first cell in column B by selecting FORMAT
CONDITIONAL FORMAT
Take the "$"-sign out of the row number ( $A$1 should be $A1, or just A1)
select a format, then either copy and paste special formats
or use your paintbrush icon (doubleclick to use on multiple cells) and
scroll over all the cells that need this format


"etks" wrote:


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