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

thanks, ufo_pilot. maybe i wasn't clear. refer below. thanks
1% 2% the 2% should be in blue because it is greater than cell A2
2% -1% the -1% should be in red because it is less than cell A3
3% -2% the -2% should be in red beause it is less than cell A4
8% 5% the 5% should be in blue because it is greater than cell A5
please take that the numbers in the rows of column A and B will change
constantly, which is why I need
to use conditioning formatting otherwise I have to colour it manually


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