Flag when condition met
 

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

Flag when condition met
 

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

Flag when condition met
 

Thanks David

However, I understand that the OR function is limited to 30 logical
arguements but my spreadsheet has 21 columns all of which have at least 2
conditions ie no. of characters and text or number so I don't see that this
solution would allow me to cover all the possible errors in a row.

G

"David Biddulph" wrote:

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

Flag when condition met
 

You could always use hidden columns to group a number of conditions
together, and then OR those.
--
David Biddulph

"Constantly Amazed" wrote in
message ...
Thanks David

However, I understand that the OR function is limited to 30 logical
arguements but my spreadsheet has 21 columns all of which have at least 2
conditions ie no. of characters and text or number so I don't see that
this
solution would allow me to cover all the possible errors in a row.

G

"David Biddulph" wrote:

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

Flag when condition met
 

Thanks David

Sometimes the simple stuff just gets buried. Have a great Christmas.

"David Biddulph" wrote:

You could always use hidden columns to group a number of conditions
together, and then OR those.
--
David Biddulph

"Constantly Amazed" wrote in
message ...
Thanks David

However, I understand that the OR function is limited to 30 logical
arguements but my spreadsheet has 21 columns all of which have at least 2
conditions ie no. of characters and text or number so I don't see that
this
solution would allow me to cover all the possible errors in a row.

G

"David Biddulph" wrote:

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