Imagine you're checking a sheet, and you find errors such ... a rule that applies ISERROR Excel function to the range in question. You can use conditional formatting for task management scenarios ...

or years), whereas the NETWORKDAYS function calculates the number of working/business days between two dates. Read Next: How to set up conditional formatting in Excel for dates.