Try using Conditional Formatting instead.

Select A1. Choose Format/Conditional Formatting. Enter

CF1: Formula is =A210
Format1: Patterns/Red

Click OK.

Now when you enter a value 10 in A2, cell A1 turns red.

If you need more than 3 conditional colors, you'll have to use an event
macro, such as a Worksheet_Calculate or Worksheet_Change:

http://cpearson.com/excel/events.htm


In article ,
Don wrote:

I'm trying to create a logical "if" statment that will turn a cell one color
or another depending on what is in another cell. How does one insert/trigger
a macro in a function?