Sorry, I miss the color
green

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Or use a custom cell format

0.00;[Red]-0.00



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Norman Jones" wrote in message ...
Hi Matt,

Try using conditional formatting:

Data | Conditional formatting...

Condition1
Formula is: =A1=0
Format | select a green pattern

Condition 2
Condition1
Formula is: =A1<0
Format | select a red pattern

---
Regards,
Norman



"Matt_70501" wrote in message ...
Could someone please help me write a macro that changes the colorIndex of a
cell based on it's value. I want all positive numbers in my selection to be
green and all negative numbers to be red... this should be easy but I need
help!

Thanks,

Matt