What is conditional formatting ??? From one of the great leaps forward in succeeding versions of Microsoft Excel it has been in clarifying information in…