Excel Macro to change font color based on font color

January 6, 2012 at 08:38:53
Specs: Windows XP
I have several Excel workbooks that each month I copy and change the names from the previous month to the current month, (ie Dogs 11/2011 to Dogs 12/2011) the worksheet has several formulas, vlookups, etc. For the cells that I need to update with current month information I change from the font color being blue to red so I know I need to input new values into the cells, once I input the new value I change the font color back to blue so I know they have been updated, I repeat this every month. Pretty much everything that doesn’t have to be updated is in black font.

Is there a way that I can select every tab in the workbook and run a macro that will find everything with blue font and change it to red?


See More: Excel Macro to change font color based on font color

Report •

January 6, 2012 at 08:57:50
Find and Replace can do this for you.

Base the Replace All by using the Format drop downs and set Within to workbook.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

January 6, 2012 at 12:03:39
Thanks, it worked like a charm!

Report •

Related Solutions

Ask Question