Is there a way I can make the font white when a #DIV/0! error occurs in a cell so I need not see that...conditional formatting maybe...some other way?
Is there a way I can make the font white when a #DIV/0! error occurs in a cell so I need not see that...conditional formatting maybe...some other way?
Good afternoon AndreLaplume
For, say cell A1, go to Format > Conditional Formatting
Select "Formula Is" and put this formula in the box :
=ERROR.TYPE(A1)=2
and set your format.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks