Conditional formatting cells with formulas = "#VALUE!"
 

I want to conditionally format a cell that 1) contains a formula and 2) the
the result of the formula equals "#VALUE!"
--
Marc

Conditional formatting cells with formulas = "#VALUE!"
 

Change the condition to FORMULA IS and use the following formula:

=ERROR.TYPE(C2)=3

Replace C2 with the cell you are formatting.
--
Kevin Backmann


"Marcus Analyst" wrote:

I want to conditionally format a cell that 1) contains a formula and 2) the
the result of the formula equals "#VALUE!"
--
Marc