Mainly to highlight cells that return a formula result that is TRUE, FALSE or >= some value, or between one value and another value. I am not good at Excel but I use conditional formatting a LOT. I have recently made the mistake of upgrading from Excel for mac 2008 to 2011.