Solved Excel - Cell / font Colour change

July 31, 2013 at 08:17:06
Specs: Windows XP
I have a spreadsheet which is pre populated with information.

I require to m,ake amendments to this but I want to be able to track my changes but rather than a bubble showing the changes I want the cell or font to change colour.

How can I do this? And can i do it without VBA?


See More: Excel - Cell / font Colour change

July 31, 2013 at 08:28:02

Report •

July 31, 2013 at 08:33:26
thanks but I need the page to show the change in a more obvious manner such as a bold colour of font or a bright cell colour.

Report •

July 31, 2013 at 10:22:01
✔ Best Answer
Well, with VBA it would be very simple, even though you said you didn't want that:

This most rudimentary code will simply fill any cell where a change is made with Green:

Private Sub Worksheet_Change(ByVal Target As Range)
 Target.Interior.ColorIndex = 4
End Sub

Another (less efficient) option is to make a duplicate copy of the sheet in the same workbook and use Conditional Formatting.

1 - Right click your sheet tab and choose Move or Copy
2 - Select a location for the duplicate sheet
3 - Click the Create A Copy box
4 - Rename the new sheet, e.g. Dup
5 - Back in the original sheet click the triangle above the Row numbers to select the entire sheet
6 - Home tab...Conditional Formatting...New Rule...Use a Formula...
7 - Enter this formula: =A1<>Dup!A1
8 - Choose a format (Bold, Fill Color, etc.)
9 - Click OK

Whenever you make a change to any cell in the original sheet, the cell will be formatted based on your formatting selection because that cell will no longer equal the corresponding cell in the duplicate sheet.

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

message edited by DerbyDad03

Report •

Related Solutions

August 1, 2013 at 01:34:27
Thank you so much.

I ended up using the VBA - I thought it was going to be more complex - im a bit of a novice with VBA. The conditional formatting wouldnt work for me and I got frustarted.

Thanks again.

Report •

August 1, 2013 at 06:00:49
OK, I'm glad you got something working.

I'm not sure what didn't work with the Conditional Formatting. I just followed the steps I posted and it worked just fine.

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

Report •

Ask Question