You do not a formula, just Conditional Formatting.

Select column A
Menu FormatConditional Formatting
Set condition to equal, and the first value
Click the Format button
Select the Pattern Tab
Select red
OK
OK

Second condition

Click Add
Set condition to equal, and the second value
Click the Format button
Select the Pattern Tab
Select green
OK
OK

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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.