Thread: [Solved] Divide by zero error
View Single Post
 
Old 08-16-2016, 05:09 AM
c991257 c991257 is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Mar 2014
Location: Zambia
Posts: 61
c991257 is on a distinguished road
Default

outatail. Conditional formatting cannot control the value of a cell. If you want it to be blank then the formula in the cell must return the value "".

Conditional formatting to control the color of the cell, borders and contents based on the value of a cell.
Reply With Quote