Solved

Conditional formatting when #value! occurs (excel 2003)

Posted on 2011-03-16
4
159 Views
Last Modified: 2012-08-14
What do I write in the conditional formatting cell to accomplish that these cells get highlighted red.

Thanks,
JP
0
Comment
Question by:easycapital
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 334 total points
ID: 35147020
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
 
LVL 6

Assisted Solution

by:Eric Zwiekhorst
Eric Zwiekhorst earned 166 total points
ID: 35147028
Conditional formating

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

kind regards

Eric
0
 
LVL 50

Assisted Solution

by:barry houdini
barry houdini earned 334 total points
ID: 35147052
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
 

Author Closing Comment

by:easycapital
ID: 35158581
Excellent!
JP
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question