Macro that is column specific & changes cell color depending on cell contents

**zurispowell** · 08-25-2012, 01:25 PM

Hi All,

So i'm trying to create a macro that is specific to only a specific part of column F. More information can be added to column, so i would need the range to be dynamic.

The data in column F uses VLOOKUP to populate the cells, however information can also be manually inputted to override the VLOOKUP data. Finally, at the bottom of column F there are cells containing the SUM Function, and these cells add data from various other parts of the spreadsheet.

I am trying to provide a different color for the manually inputted cells, the VLOOKUP cells and leave any other cells in this column (containing text, the totals or empty) with a "No Fill Font".

I would also like to initiate this Macro whenever a change is made to the cell. So if for example i was to manually enter a value in Column F, the macro will initiate automatically, without me having to press "Run Macro"

Below is my code to-date.

Please Login or Register  to view this content.

**Cutter** · 08-25-2012, 01:49 PM

@ zurispowell

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

**watersev** · 08-25-2012, 05:03 PM

hi zurispowell, welcome to Excelforum, option to make it, please check attachment. Try to input values in F4:F165 on Sheet1. If colouring does not appear, run code "EnablEvents" and try again.