Reply to thread

Message: [QUOTE="totinnere, post: 6348910"] Good afternoon, everyone. I've been banging my head against the wall trying to figure this out for a few days. I am looking to create a shared workbook and utilize the track changes feature. In this workbook I want to write a function that refers to another cell and tells me whether or not that cell is highlighted as being changed (i.e. has the blue triangle in the top left corner). It is extremely important that it refers to whether or not Excel is highlighting it because I want the function result to change if the highlight change date range is changed. I figured out how to have the function check a cell for comments, but since these only look like comment it doesn't work. I'm hoping the VBA language is similar, but for the life of me I can't find how to reference the highlight for change. Any help would be greatly appreciated! [/QUOTE]