Highlight if changed, conditional format.

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,810
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Not conditional formatting. WorkSheet Change. Your question is really not very clear, so maybe this will get you started?
Code:
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

Well-known Member
Joined
Jan 14, 2003
Messages
1,810
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Thank you lenze.
 

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,810
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
I just become member of your site box.net
thanks for that too.
 

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,810
Office Version
  1. 365
  2. 2016
Platform
  1. Windows

ADVERTISEMENT

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

Well-known Member
Joined
Jan 14, 2003
Messages
1,810
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
or a better example below
2006 Fixed Assets Additions.xls
ABCDEF
1116001-0010LAND10,141,477
1216002-00XXLAND-MEDPLEXES32,897,9795691
1316003-00XXLAND-BRAESWOOD-MARRIOTT13,155,282
1416004-0080LAND-6540FANNIN1,283,351
1516005-0080LAND-6540FANNIN305,553
1616006-0091LAND-SACKETT0
1716007-0081LAND-TWU7,860,4394,282,474
1816008-0087LAND-IOR0
1916009-0081LAND-ESCROW22,500,000(4,243,269)
2016010-0081LAND-WESTPAVILLION5,642,676
2116011-0080LAND-CLEARLAKE7,7104,760
2216012-0080LAND-KATY124,3004,418,920
23
24TOTALLAND93,918,7684,468,576
25
2616101-0010LANDIMPROVEMENTS1,992,267154,633
27
2816201-0010BUILDING-MAIN557,477,6781,909,296
2916250-0010BUILDING-ACCRUAL7,408,543
5615


thanks
 

Forum statistics

Threads
1,136,618
Messages
5,676,844
Members
419,655
Latest member
pd2021vb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top