• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

Conditional formatting when #value! occurs (excel 2003)

What do I write in the conditional formatting cell to accomplish that these cells get highlighted red.

Thanks,
JP
0
easycapital
Asked:
easycapital
  • 2
3 Solutions
 
barry houdiniCommented:
For any error to be highlighted you can use this formula in CF

=ISERROR(A1)

or for specifically #VALUE! try

=ERROR.TYPE(A1)=3

regards, barry
0
 
Eric ZwiekhorstSAP Business ConsultantCommented:
Conditional formating

Fomula is     =ISERROR(B11) 'where B11 is the range you want to check for #NA

kind regards

Eric
0
 
barry houdiniCommented:
In the attached I used the ISERROR version in column A but ERROR.TYPE to isolate #VALUE errors in column B

regards, barry
26890378.xls
0
 
easycapitalAuthor Commented:
Excellent!
JP
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now