Goto

[jtodd]

HI ,
I have a sheet that imports data from a database , problem is that occasionaly the data has a currupt line in it wich then throws up an error on the sheet which in turn currupts the calculations on the sheet.
what i would like is a way of allerting the user that there is an error on the sheet ,
I have conditional formatting to do this at the moment but this needs the user to remember to look for errors ( may not be visable)
Is there a way for a warning to appear when the user opens and refreshes the sheet if there are anyt errors

 

[Yongle]

what is the conditional formatting rule applied which highlights errors?

are you currently using VBA to import the data?

 

[jtodd]

Conditional formadtting rule =iserror(A!)
use microsoft query to import the data from and access database

 

[Yongle]

I think you mean
=ISERROR(A1)

Rather than a message (which requires VBA) you could add another rule that turns the whole of column A red and also shows the actual errors

Assuming that the error is always in column A...
Select column A and add another rule with this formula
=ISERROR(SUM(A:A)) and colour fill with a different colour to the one used for the other rule

Make the rules apply in the correct order (see picture)