Each cell should change if the condition is meet.
Preferably just the number and not the cell.

Dan
-----Original Message-----
Format / Conditional Formatting should do it. Do you
want the whole column to turn red if a
certain number anywhere is greater than .5, or do you
want each cell in that column to turn red if
the number in it is greater than .5

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL2K & XLXP

---------------------------------------------------------
-------------------
Attitude - A little thing that makes a BIG difference
---------------------------------------------------------
-------------------



"Dan" wrote in message
...
I have a spreadsheet that I would like just one column
to
change color to red if the number in the column is
greater than .5 otherwise I don't want anything to
happen. I assume that this would be a VB coding issue.

Thx
Dan


.