It checks if Excel contains a number in a cell or not. The ABS function is used in Excel to change the sign of the number to positive or its absolute value. Here are a couple of Excel formulas we can use to get our reconciliation done before lunch.
The information in this article applies to Excel versions 2019 2016 and 2013 as well as Excel for Microsoft 365 and Excel for Mac.
Click OK then OK again to get back to the Conditional Formatting Rules Manager. It checks if Excel contains a number in a cell or not. The number of days can quickly be determined by subtracting the Alloc End and Alloc Start dates. Negative_value-1 Below you have a range of cells with negative numbers.