excel windows 97

  • Thread starter Thread starter emcallahan
  • Start date Start date
E

emcallahan

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.
 
Have a look at conditional formatting
Format>conditional format>cell value is>greater than 10>format as desired
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top