Highlight if changed, conditional format.

[srizki]

I like to know the formula for conditional formatting, if a cell is changed, it should highlight with whatever color is in conditional format.

Thanks

 

[lenze]

Not conditional formatting. WorkSheet Change. Your question is really not very clear, so maybe this will get you started?

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    If Target.Column <> 2 Then Exit Sub 'Limit to column B
    Target.Interior.ColorIndex = 6 'Color cells in column B that are changed to yellow
End Sub

lenze

 

[srizki]

Thank you lenze.

 

[srizki]

I just become member of your site box.net
thanks for that too.

 

[srizki]

For example
10,141,477
32,897,979
13,155,281
1,283,391
305,563
16,293,354
0
14,106,625
5,642,655
16,119
4,543,220

if someone changes any of these numbers it should highlight, like track changes, highlight changes.

 

[srizki]

or a better example below

2006 Fixed Assets Additions.xls
	A	B	C	D	E	F
11	16001-0010	LAND	10,141,477
12	16002-00XX	LAND-MEDPLEXES	32,897,979		5691
13	16003-00XX	LAND-BRAESWOOD-MARRIOTT	13,155,282
14	16004-0080	LAND-6540FANNIN	1,283,351
15	16005-0080	LAND-6540FANNIN	305,553
16	16006-0091	LAND-SACKETT	0
17	16007-0081	LAND-TWU	7,860,439		4,282,474
18	16008-0087	LAND-IOR	0
19	16009-0081	LAND-ESCROW	22,500,000		(4,243,269)
20	16010-0081	LAND-WESTPAVILLION	5,642,676
21	16011-0080	LAND-CLEARLAKE	7,710		4,760
22	16012-0080	LAND-KATY	124,300		4,418,920
23
24		TOTALLAND	93,918,768		4,468,576
25
26	16101-0010	LANDIMPROVEMENTS	1,992,267		154,633
27
28	16201-0010	BUILDING-MAIN	557,477,678		1,909,296
29	16250-0010	BUILDING-ACCRUAL	7,408,543
5615

thanks

 

[lenze]

Hi. If you really want to track changes, see my code here for adding comments to cells when a change is made.

http://www.mrexcel.com/board2/viewtopic.php?p=1088487#1088487

lenze