Goto

jtodd

Board Regular
Joined
Aug 4, 2014
Messages
147
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
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,872
Office Version
  1. 365
Platform
  1. Windows
what is the conditional formatting rule applied which highlights errors?

are you currently using VBA to import the data?
 

jtodd

Board Regular
Joined
Aug 4, 2014
Messages
147
Conditional formadtting rule =iserror(A!)
use microsoft query to import the data from and access database
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,872
Office Version
  1. 365
Platform
  1. Windows
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

Result err.jpg



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)
CF rule err.jpg
 

Watch MrExcel Video

Forum statistics

Threads
1,118,294
Messages
5,571,372
Members
412,385
Latest member
OChambo94
Top