excel windows 97
 

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.

excel windows 97
 

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.

excel windows 97
 

Hi "emcallahan"

No need to us VB when conditional formatting is available.

Format Condition Formatting
Cell Value Is
Greater Than
10
Format
Select to taste
OK
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.