Excel’s conditional formatting is much more useful than it initially seems to be. You don’t need to base the formatting you set upon the value of the cell you’re formatting; you can format one cell based on the value of a different cell.
In fact, you can base the formatting on formulas and not just on […]

continue reading.....