View Single Post
 
Old 12-20-2016, 10:03 AM
deejay deejay is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Dec 2016
Posts: 4
deejay is on a distinguished road
Smile

That works.

I noticed that the Manage Rules dialog box shows the formula in your wb to be exactly:
Formula:=D$2=0

whereas in mine, after I entered it just that way, showed
Formula:="D$2=0"

When I removed the double quotes from mine it worked. Excel seems to have inserted specifically what broke the Conditional Formatting. I seem to recall something like this in Excel several versions of Office back. Has that fault been "re-implemented" in Excel 2016 ? Any chance MS will ... fix it ?

Thanks very much.

Last edited by deejay; 12-20-2016 at 10:05 AM. Reason: forgot social graces
Reply With Quote