can be reduced to:
If you were to put that shortened formula in a cell, it would return either TRUE or FALSE based on the values in the cells.
Since CF is looking for either TRUE or FALSE, you don't need to force the return of those logical values with an IF function. They will occur "naturally" and CF will be quite happy to use them. Keeping that in mind, you will save a lot of keystrokes when writing CF rules.
When you Select multiple cells and apply CF Rules, the rules are applied individually to each cell.
e.g. If you:
1 - Select B1:B3
2 - Use =B1>A1 as your 1st rule
3 - Format as Green
4 - Use =B1=A1 as your 2nd rule
5 - Format as Orange
B1 will be formatted based on the value in A1
B2 will be formatted based on the value in A2
B3 will be formatted based on the value in A3
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.