Hi,

Let's assume that the data start at Row 2 (i.e., the first pair of numbers
are in A2 and B2).
Format the entire column B for Blue font. Now select the entire range in
column B (e.g., B2:B301) -- "Format" -- "Conditional Formatting" --
"Formula Is" =$B2<$A2, format the font to be Red -- "OK" (Note that there
are no $ symbols before the '2's in the formula).

If you want the Conditional Formatting to be able to accommodate more rows
as additional data are added over time, select an extended range (e.g.,
$B2:$B501) instead of the actual data range ($B2:$B301) before you do the
font-formatting vis-a-vis CF.

Regards,
B. R. Ramachandran


"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