Hi
why not use Conditional Format for this?. Simply select your data range
and goto 'Format - Conditional Format' for this

--
Regards
Frank Kabel
Frankfurt, Germany


Kura of Tyren wrote:
Does anyone know how I can make a macro that will search
all cells within a preset range and change the font color
of all cells with a value of less than 20 to red while
leaving all other cells in the region with their normal
color?