Conditional formatting cells with formulas = "#VALUE!"

  • Thread starter Thread starter Marcus Analyst
  • Start date Start date
M

Marcus Analyst

I want to conditionally format a cell that 1) contains a formula and 2) the
the result of the formula equals "#VALUE!"
 
Change the condition to FORMULA IS and use the following formula:

=ERROR.TYPE(C2)=3

Replace C2 with the cell you are formatting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Conditional Formatting 6
conditional formatting 1
Refering to a cell above another cell 3
Excel 2007 - A Conditional Formatting ?'s 1
Conditional Formatting - Excel 2003 2
can conditional formatting varry the area it highlights based on c 3
Help with conditional formatting 1

Back
Top