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.