Rule no: 1 is, in conditional formatting, your formula should be a logical formula and result should be in TRUE or FALSE. In the below example, we have used
