Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2016, 12:36 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional formating all cells in an array based on adjacent cells Windows 7 64bit Conditional formating all cells in an array based on adjacent cells Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Select the range to format ( D3:AA3,say)
Open CF wizard
New rule enter =D$2=0
Format as needed
Done


( the $ sign before the row number is important)
__________________
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
Reply With Quote
  #2  
Old 12-20-2016, 09:32 AM
deejay deejay is offline Conditional formating all cells in an array based on adjacent cells Windows 7 64bit Conditional formating all cells in an array based on adjacent cells Office 2016
Novice
Conditional formating all cells in an array based on adjacent cells
 
Join Date: Dec 2016
Posts: 4
deejay is on a distinguished road
Unhappy no bueno

Nope, that didn't work either. I understand fixing the row and/or column value in a cell reference, and thought (if that had worked) that it would be odd to make fixing the row value force the column value to slew through the application of that rule. But, it didn't do that anyway. After applying that rule exactly as described, each cell *shows* D2 (the criteria cell for the origin cell in the array) as its criteria cell - but even with that the conditional formatting does not work on ANY of the cells in the array.

FWIW, this is not the first time that expert advice that works in one copy of MS Excel 2016 simply doesn't work in another. I am more convinced than ever that Excel (and to a lesser degree the other major Office apps) has just been totally screwed up by the decline in dev discipline and attitude at MS over the past 10-12 years. As much as I think the G suite Spreadsheets is inferior in its set of features, I will probably have to shift to that since what they do offer actually works.

But thanks for trying.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formating all cells in an array based on adjacent cells 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
Conditional formating all cells in an array based on adjacent cells 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
Conditional formating all cells in an array based on adjacent cells 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft