Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight upon change
Can u write a code to highlight a cell with any color if its value is
changed. Actually I am working at a Head Office and am collecting data from branches on a sheet that I am distributing however I have to keep a check if the original values have not been changed. Please consider the example: Action 1: Cell A1 has a value "5" if someone turns it to "6" the cell turns to Red. Action 2: Upon a realizing that he has made a mistake if he turns it back to "5" the cell is no longer highlighted. If it even doesn't work the second time, that is reverting back to non-highlighted, even a code for only the first action would also be higly obliged. Thanx! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight upon change
My thoughts on this is to create a copy of the worksheet and then protect and
hide it. When it is returned a macro could be used to compare the data on the returned worksheet with the data on the copy and color any non matching cells. Would this meet your requirements? Would you like me to write a macro for you? If so then what version of xl are you using? What is the range of the data to be checked? That is from cell A1 to ????. There are ways of finding the last cell but if it is always within a fixed range then that makes life easy. Do you need instructions to copy the macro to the workbook and run it? Could also create a worksheet with a list of the changed cells with the old and new values. Regards, OssieMac "FARAZ QURESHI" wrote: Can u write a code to highlight a cell with any color if its value is changed. Actually I am working at a Head Office and am collecting data from branches on a sheet that I am distributing however I have to keep a check if the original values have not been changed. Please consider the example: Action 1: Cell A1 has a value "5" if someone turns it to "6" the cell turns to Red. Action 2: Upon a realizing that he has made a mistake if he turns it back to "5" the cell is no longer highlighted. If it even doesn't work the second time, that is reverting back to non-highlighted, even a code for only the first action would also be higly obliged. Thanx! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight upon change
Thanx Mac
I could have used the conditional formatting in this regard on the hidden sheet. The macro required earlier was for the sake of my developing interest and information. Creating an extra sheet would upsize the file, which is already heavy, making it difficult to be uploaded and emailed. I only want the branch managers themselves to realize that they can't manipulate the originally provided data. Please c if u can help me with a code for the same sheet. Thanx again "OssieMac" wrote: My thoughts on this is to create a copy of the worksheet and then protect and hide it. When it is returned a macro could be used to compare the data on the returned worksheet with the data on the copy and color any non matching cells. Would this meet your requirements? Would you like me to write a macro for you? If so then what version of xl are you using? What is the range of the data to be checked? That is from cell A1 to ????. There are ways of finding the last cell but if it is always within a fixed range then that makes life easy. Do you need instructions to copy the macro to the workbook and run it? Could also create a worksheet with a list of the changed cells with the old and new values. Regards, OssieMac "FARAZ QURESHI" wrote: Can u write a code to highlight a cell with any color if its value is changed. Actually I am working at a Head Office and am collecting data from branches on a sheet that I am distributing however I have to keep a check if the original values have not been changed. Please consider the example: Action 1: Cell A1 has a value "5" if someone turns it to "6" the cell turns to Red. Action 2: Upon a realizing that he has made a mistake if he turns it back to "5" the cell is no longer highlighted. If it even doesn't work the second time, that is reverting back to non-highlighted, even a code for only the first action would also be higly obliged. Thanx! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight upon change
What about copying the worksheet to another workbook. That way the macro
could reside in the workbook with the copy and it would not change the size of the workbook to be distributed and because you would be the only one who has the copy then it does not need to be protected or hidden. Regards, OssieMac "FARAZ QURESHI" wrote: Thanx Mac I could have used the conditional formatting in this regard on the hidden sheet. The macro required earlier was for the sake of my developing interest and information. Creating an extra sheet would upsize the file, which is already heavy, making it difficult to be uploaded and emailed. I only want the branch managers themselves to realize that they can't manipulate the originally provided data. Please c if u can help me with a code for the same sheet. Thanx again "OssieMac" wrote: My thoughts on this is to create a copy of the worksheet and then protect and hide it. When it is returned a macro could be used to compare the data on the returned worksheet with the data on the copy and color any non matching cells. Would this meet your requirements? Would you like me to write a macro for you? If so then what version of xl are you using? What is the range of the data to be checked? That is from cell A1 to ????. There are ways of finding the last cell but if it is always within a fixed range then that makes life easy. Do you need instructions to copy the macro to the workbook and run it? Could also create a worksheet with a list of the changed cells with the old and new values. Regards, OssieMac "FARAZ QURESHI" wrote: Can u write a code to highlight a cell with any color if its value is changed. Actually I am working at a Head Office and am collecting data from branches on a sheet that I am distributing however I have to keep a check if the original values have not been changed. Please consider the example: Action 1: Cell A1 has a value "5" if someone turns it to "6" the cell turns to Red. Action 2: Upon a realizing that he has made a mistake if he turns it back to "5" the cell is no longer highlighted. If it even doesn't work the second time, that is reverting back to non-highlighted, even a code for only the first action would also be higly obliged. Thanx! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight upon change
Hi,
For more information, please look at this demo on Conditional Formating: http://office.microsoft.com/en-us/ex...CL100570551033 Challa Prabhu "FARAZ QURESHI" wrote: Can u write a code to highlight a cell with any color if its value is changed. Actually I am working at a Head Office and am collecting data from branches on a sheet that I am distributing however I have to keep a check if the original values have not been changed. Please consider the example: Action 1: Cell A1 has a value "5" if someone turns it to "6" the cell turns to Red. Action 2: Upon a realizing that he has made a mistake if he turns it back to "5" the cell is no longer highlighted. If it even doesn't work the second time, that is reverting back to non-highlighted, even a code for only the first action would also be higly obliged. Thanx! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i change the color of the GUI highlight area? | Excel Discussion (Misc queries) | |||
Any way to highlight cells that change? | New Users to Excel | |||
Change highlight cell color | Excel Discussion (Misc queries) | |||
Highlight entire document and try to change font - won't change. | Excel Discussion (Misc queries) | |||
change cursor to highlight cell I'm in | Excel Worksheet Functions |