Solved

Conditional formatting when #value! occurs (excel 2003)

Posted on 2011-03-16
4
152 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
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 334 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Excellent!
JP
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now