Highlight your cells then

Format=Conditional Formatting=Formula is:=NOT(ISNUMBER(FIND(0,A1))) and
set colour as required

Assumes A1 is top left of your range.

HTH

"Rothman" wrote:

I have a 120x120 matrix of five digit numbers like so:

52000 42222 43213 01016
52020 42200 43202 01000
52000 42202 43103 01016
52020 42200 43100 01000
52300 42000 43002 01010
52300 42020 43010 01010
53000 40222 41213 01216
53020 40200 41202 01200
53000 40232 41103 01006

...and so forth.

I want to highlight the cells that do not include a zero (the reverse works
as well for me, highlighting the cells that do include a zero). I can't seem
to make an if statement with find or search work out.

Thanks in advance.