Conditional formating all cells in an array based on adjacent cells

deejay · #5 12-20-2016, 10:03 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding adjacent cells and having the sum appear in two separate places	Seamus Sean	Excel	4	12-11-2016 10:34 PM
Using alternating borders in adjacent cells	jrevard	Word	0	10-15-2015 09:07 AM
How to conditionally format cells in Col. A if it matches adjacent cell in Col. B?	alshcover	Excel	2	06-03-2014 12:50 PM
How can I count cells based on their fill color that was set by conditional format	trueimage	Excel Programming	1	10-25-2013 12:08 PM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell	Frogggg	Excel	1	10-25-2011 08:44 PM