Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-25-2011, 12:21 PM
avanderh avanderh is offline Conditional color fill based on presence of data Windows 7 32bit Conditional color fill based on presence of data Office 2007
Novice
Conditional color fill based on presence of data
 
Join Date: Jul 2011
Posts: 6
avanderh is on a distinguished road
Default Conditional color fill based on presence of data

Hi,

I am trying to format an excel sheet so that when a specific cell changes color, so does another group of cells. However, I do not want all cells in the group to change color, only the ones that have data entered. For example, if cell A1 is the independent cell, changing its color will change the color of all cells A2:A10, but only for the ones that have something entered in, leaving the rest as no-fill. Furthermore, I would like it so that if I enter data in any of the cells in the group (A2:A10) that it will automatically change color to be the same as cell A1.

To summarize, I pretty much want the group to act as though it is conditionally formatted for non-blank cells, while responding to the color of one particualr cell. Is this possible and, if so, how can I do it?

Thanks,
Alex
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I fill the below emty cells with above cell data? Learner7 Excel 8 06-28-2011 12:10 PM
Conditional color fill based on presence of data Conditional data validation (list drop-down) click4akshay Excel 2 04-28-2011 01:51 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM
Conditional color fill based on presence of data Conditional Expression that Moves Data (challenging) themangoagent Excel 1 02-20-2010 11:29 AM
Conditional color fill based on presence of data Change Automatic Fill Color Leanne PowerPoint 1 11-04-2009 08:34 PM

Other Forums: Access Forums

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