click the cell(s)
goto format
conditional formatting and add your arguments ( you will understand
once your in there

e.g if cell value is 1000 then (click format button) and change text
colour to green

etc
etc


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=561882