I would have thought that the easiest way might be to include an extra
column to flag an error on a row by combining (with OR) the error conditions
for the cells on that row, and then finally combining with OR the cells in
that column. If that cell does indicate an error and you want to find the
rows with errors in them, you could autofilter on the error column looking
for a TRUE value.
--
David Biddulph

"Constantly Amazed" wrote in
message ...
Hi

I have a large spreadsheet which is to be used to populate a database with
catalogue details. I have used conditional formatting to highlight any
cells
where an inappropriate entry has been made ie length, number/text or
blanks
(each column has a different set of criteria). However, rather than have
to
visually check the entire spreadsheet to see if any errors had been
highlighted it would be extremely useful if at the top I had a cell which
would flag if any of the cells in the spreadsheet had met the set
conditions.
If the flag indicated that no cells had inappropriate entries all well and
good or if it did indicate an error then I could look for the highlighted
cell in the data.

Thanks