#DIV/0! and IF statement
Go to tools and click conditional formatting. Click on the drop down
list and select "Formula is" then type this in the text box next to it
=ISERROR(C3)
Then click format button and click the color drop down box and select
white. (Even if the orginal color of the color drop down box is white
still click on it and select white or it will not work)
|