This works for your stated conditions?

--
Regards,
Tom Ogilvy



"teresa" wrote in message
...
Great Bob - thanks



"Bob Phillips" wrote:

Hi Teresa,

Here is some code

Dim cell As Range

For Each cell In ActiveSheet.UsedRange
If cell.Value = 0 And cell.Column < 11 And cell.Column < 15
Then
cell.Font.Color = RGB(&HFF, &HFF, &HFF)
End If
Next cell


--

HTH

RP
(remove nothere from the email address if mailing direct)


"teresa" wrote in message
...
In my spreadsheet I have unticke the "View Zeros" option but I need
all
values in column O and row K to show zeros, I need a macro to
condition
this for these
particular cells

Thanks