Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Fill cells based on value
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 11-09-2017, 04:36 AM
hiwire03 hiwire03 is offline Fill cells based on value Windows 7 32bit Fill cells based on value Office 2013
Novice
Fill cells based on value 		 
Join Date: Dec 2014
Posts: 17
hiwire03 is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
If A1=7 do you mean that A2:A8 must have a color, if A1=3 then A2:A4 must have a color and so on?
That is correct
Reply With Quote
  #2  
Old 11-09-2017, 04:44 AM
xor xor is offline Fill cells based on value Windows 10 Fill cells based on value Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
See the attached.
Attached Files
File Type: xlsx FillCells.xlsx (8.9 KB, 11 views)
Reply With Quote
  #3  
Old 11-09-2017, 08:50 AM
hiwire03 hiwire03 is offline Fill cells based on value Windows 7 32bit Fill cells based on value Office 2013
Novice
Fill cells based on value 		 
Join Date: Dec 2014
Posts: 17
hiwire03 is on a distinguished road
Default
Great, very close to what I've been looking.
Except I would like to start the fill at a preferred cell.
Would appreciate if you could educate me on how to do it?

Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill cells based on value Form auto fill based on a different field value. stct Word 31 05-02-2024 04:48 PM
Conditional formating all cells in an array based on adjacent cells deejay Excel 6 12-20-2016 12:00 PM
Color-fill a range of cells, based on text in a different sheet. Possible? unittwentyfive Excel 2 06-01-2014 06:48 AM
Fill cells based on value 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
Fill cells based on value How-TO format cells (FILL) by comparing cells zanat0s Excel 1 07-03-2012 04:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:49 PM.

Contact Us - Privacy Statement - Top

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