Have a look at conditional formatting
Formatconditional formatcell value isgreater than 10format as desired

--
Don Guillett
SalesAid Software

" wrote in
message ...
A user would like to know how if there's a way in Excel
(maybe using VB) to have a cell color change if it meets
certain criteria. For example, if the cell value is
greater than 10 it turns red.