I have a time tracking spreadsheet that I have the following formula “=B10-($B$4-10)” in place.  The bold section number value of the formula is manually changed to reflect the line of the largest value to give the variance/shortage.  Can this be modified to select this as it occurs?

​I have a time tracking spreadsheet that I have the following formula “=B10-($B$4-10)” in place.  The bold section number value of the formula is manually changed to reflect the line of the largest value to give the variance/shortage.  Can this be modified to select this as it occurs?  Read More

​