This would normally be done with Conditional Formatting
for some help with C.F. see
http://www.mvps.org/dmcritchie/excel/condfmt.htm

or with an event macro
http://www.mvps.org/dmcritchie/excel/condfmt.htm#case


A formula cannot change the formatting of any cell, including itself.
This is not a conflict with Conditional Formatting since it is not
actually changing the formatting -- remove the C.F. and it is like
it was never there.

Conditional Formatting uses regular Worksheet Formulas, or
the equivalent. I'd stick to always explicitly using formulas myself.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Atul Shah" <Atul wrote in message ...
I'm looking to see if there is a formula or macro to address the above query.
I want to change the colour of the cell in which the data (neumeric Value) is
stored. Based on the value the colour willb e red or green.