I suggest you to use conditional formatting instead to display the cell
background in red color if the values is negative and in green color if it is
positive. You can achieve this as follows
Suppose that your look up data is in column B then
1.Select column B
2.Click FormatConditional Formatting.. from the toolbar
3.In the dialog box, select cell value is from the leftmost drop down list
4.Select Less then from the middle drop down list
5.Enter 0 in the box at the right
6.Click the Format button and choose Red color
7.Click OK
8.Click on the Add button
9.Select cell value is from the leftmost drop down list
10. Select greater then from the middle drop down list
11. Enter 0 in the box at the right
12.Click OK

Now You are done!

Have a nice time€¦..

Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1