Solved

Conditional formatting when #value! occurs (excel 2003)

Posted on 2011-03-16
4
160 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
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…

690 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