|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
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