Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow

FAQ

Thread Tools

Display Modes

02-04-2017, 06:32 PM

FUGMAN

Windows 10 Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow

Office 2016

Banned

Join Date: Feb 2017

Posts: 55

Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow

I am looking for an Excel Macro that will do the following two tasks.

1. Clear all row colors within a range starting at cell A8 and ending at the last record in column A. The row of the last record in column A can be any row above row 8.

2. Then make the row of the active cell to be colored yellow.

Thanking you in advance for any help regarding this issue.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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