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