You don't need a macro simply use conditional formatting. select all the
cells on the worksheet and set up the conditional format to be red if the
cell contents match your criteria.

Mike

"rj" wrote:

Hi all,

I want a macro that checks through the current worksheet and colours
every cell that has a specified value.. Eg. if F12 has "BAD" typed in
it, then F12 should be coloured red..

thanks in advance..