Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-31-2017, 11:37 AM
Phil H Phil H is offline Conditional Fomatting Formats Next Cell Windows XP Conditional Fomatting Formats Next Cell Office 2010 64bit
Advanced Beginner
Conditional Fomatting Formats Next Cell
 
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default

Thanks to NBVC for the clue: the formula must refer (correctly) to the range. In this case there were two formulas for the range, one referred to Z2, the other to Z3. When the Z2 formula was changed to a Z3 reference, the problem was corrected.
Reply With Quote
 

Tags
conditional formatting, formatting adjacent cell



Similar Threads
Thread Thread Starter Forum Replies Last Post
Losing Conditional Formats Upon Macro Run Phil H Excel 3 08-26-2015 01:32 PM
Conditional Fomatting Formats Next Cell Excel Error: “Too many different cell formats”. nishant Excel 1 02-05-2014 10:50 AM
Too many different cell formats nishant Excel 1 02-05-2014 10:49 AM
Conditional Fomatting Formats Next Cell Use formula to copy cell formats also mike_abc Excel 10 12-10-2011 01:55 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:59 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