conditionally format a cell based on an error in another cell

[merlin777]

I want to hide a value in a cell if an adjacent cell contains a div/o! error.

I'm trying to do it by formatting the font white if the error is present but I can't find a way (in 2007) to apply that format if an error is present in another cell. Using a CF formula doesn't allow this.

Any suggestions?

 

[Marcelo Branco]

Maybe

=ERROR.TYPE(A2)=2

See
https://support.office.com/en-us/article/ERROR-TYPE-function-10958677-7c8d-44f7-ae77-b9a9ee6eefaa

M.

 

[merlin777]

cheers marcelo

 

[Marcelo Branco]

M.