Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-04-2017, 09:22 PM
FUGMAN FUGMAN is offline Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow Windows 10 Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow Office 2016
Banned
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow
 
Join Date: Feb 2017
Posts: 55
FUGMAN is on a distinguished road
Default

Thank you for your reply to my thread. Sorry for the confusion. Hopefully this additional input from me will make things more clear.



First step is to clear all colors from rows within a range starting at cell A8 and ending at the last row which contains data in column A

To address your questions...
The last row could be A9 or A255, A355 or beyond...depending on how many total rows with data are in column A of the spreadsheet.

My statement "above row 8" is in reference to any row number above 8. My intention is to have the macro function for all rows except rows 1 through 7.

The row to be colored is to be determined by selecting a cell (Active Cell) in the row (any row except for rows 1 through 7) that I wish to be colored yellow.
Reply With Quote
  #2  
Old 02-04-2017, 11:11 PM
FUGMAN FUGMAN is offline Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow Windows 10 Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow Office 2016
Banned
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow
 
Join Date: Feb 2017
Posts: 55
FUGMAN is on a distinguished road
Default

Additional attempt for clarification of what I am hoping to accomplish.
I want to be able to change the color of a row in my spreadsheet to yellow. I want to select that row by selecting a cell in the row that I want to be colored yellow. This is to include all rows that have contiguous data in column A, excluding rows at 1 through 7. (Starting with row at A8 plus all additional rows numbered higher than row A8 that contain data...till a blank is encountered in column A).
In addition to my original inquiry, I would also like to limit this activity to columns A thru BZ.
Before I have the color of the desired row changed to yellow, I want to have any colors removed from all rows , except for rows 1 through 7.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C rick10r Excel 1 07-05-2016 12:07 PM
Dymanic Range Starting at a Cell Defined by a Count jap7675 Excel Programming 7 12-02-2015 02:12 AM
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow If id cell range is empty then should not allow to fill any other cell ubns Excel Programming 2 04-12-2015 06:31 AM
Change formula cell range based on cell value Scoth Excel 4 10-25-2012 07:51 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:41 AM.


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