How to format whole row or a Range by Conditional Formating

Sometimes in Excel, we need auto-formatting as soon as a condition in a particular cell or cell range is satisfied then the formatting of the whole row or a cell range should change. This is very easy to do in Excel by using Conditional Formatting. Let's take an example. Suppose you have following data in the Excel Sheet [...]