Shortcut for conditional formatting in Excel 2011 in OS X
press Alt + O + D and In the New Formatting Rule dialogue box, select the option 'Use a formula to determine which cells to format'. Set the format that you want to apply to the cells that are blank or have errors.