I want to write a macro that will search through a sheet and find numbers
that are hard coded, not the result of formulas, and the in that cell write a
blue 0.

The writing in blue is ancillary to the ability of finding the hard coded
numbers and zeroing them.
Is this possible? Thanks for the help?