ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Track Changes (https://www.excelbanter.com/excel-worksheet-functions/235019-track-changes.html)

Kanmi

Track Changes
 
How can i track changes by column made to a worksheet. I have list of data like

A B C
D
NAMES ID POSITION BRANCH
Luke Kuma 0023 Manager Austin
Kela Hug 0024 Sales Rep Freno
Kim Teresa 0025 Supervisor Orlando

Now these are huge list of information updates from the database. i want to
by colour when or when new column is added to the page

A B C
D
NAMES ID POSITION BRANCH
Luke Kuma 0023 MD Freno
Kela Hug 0024 Sales Rep Freno
Kim Teresa 0025 Supervisor Orlando

New
Yuwula Loma 0026 Manager Austin

Now I want both ID 0023 and 0026 "COLUMN" that made changes this page to be
highlighted in color. "yellow". I mean that very column should be different
from other column that remain the same. please can anybody advice on what to
do. Appreciate your precious time. Thanks




All times are GMT +1. The time now is 01:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com