|
|
|
|
#1
12-20-2016, 10:41 AM
|
||||
|
||||
No
that is probably because you entered D$2=0 without the preceding = sign XL then adds the = sign and thinks your expression is a text string, I don't know why. CF has many rules not very well documented
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode