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