Conditional formatting cells with formulas = "#VALUE!"

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!"
 
K

Kevin B

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

=ERROR.TYPE(C2)=3

Replace C2 with the cell you are formatting.
 
Top