Highlits the cell when any data is entered in it to show the alteration
Guys ,
I have a sheet which i will be forwarding to another person .
the sheet is locked but some are kept unlock for him to make changes.
what i want is , is there anyway by which if the person make alteration in the
data which is already provided that cell highlits automatically , like the cell turns to yellow so that i can know that is the cell where the person has made changes.
Without VBA, you would need a set of reference values hidden somewhere. For instance, you could duplicate the values of column A in column AA and then hide AA. Then use a conditional formatting formula in column so that it highlights the cell if the cell content doesn't match the same value in the hidden column.
1) Highlight A1
2) Click on Format > Conditional Formatting
3) Use the settings:
Condition1: Formula Is: =A1<>AA1
Format... Patterns: Yellow color
================
Alternately, you could install a macro that highlights any cell that is edited, but that would require VBA to be enabled by the people you're sending the file to.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
It might also be worth investigating the 'Review/ Track changes' feature of Excel. This allows you to identify changes made since last saved.
Excel 2003 user (and starting to warm to Excel 2007)
how ?................Originally Posted by deadlyduck
the data is very large , i cant just make exact copy of data as approx 30 sheets r linked to one another. please give me another way round . i think the solution is very easy , but we cant figure it out , something to do with conditional formatting .
The only way conditional formatting can help you is with the technique I described. There has to be some data somewhere for the conditional formatting to refer to after changes have been made.
This qualifies as "very easy", just because it's potentially a lot of duplicated data doesn't make it harder, just makes it bigger. Up to you.
The "other way around" has also been suggested. Read up on Excel's "Track Changes" feature. Press F1 in Excel and search for "Track Changes" or Google "Excel Track Changes". Plenty to read.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks