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