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!