How do I create a keyboard shortcut for conditional formatting for Excel 2011 in OS X? I am unable to find any such shortcut.
Shortcut for conditional formatting in Excel 2011 in OS X
keyboardms officeshortcut
Related Solutions
There is a side-by-side Excel shortcut guide here: https://exceljet.net/keyboard-shortcuts
It's not in exactly the same format as above, but it's close.
Full disclosure: this is a resource that I created.
Found it! It's a setting under Preferences > Edit:
Extend data range formats and formulas
Misread it as "date ranges" on the first trawl through preferences. Turning it off stops this happening.
The comment about formulas seems to only mean that it doesn't fill empty cells with formulas when it thinks it's seen a pattern. After turning it off, it still does other automatic format adjustment e.g. incrementing formulas copied across a range:
Related Question
- How to find errors in Excel for Mac 2011 in a large sheet
- Conditional format cells based on match in another sheet
- Excel Shortcut – How to Insert Row
- PowerPoint for Mac – Shortcut for Bullets and Numbered Formatting
- macOS Shortcut – Keyboard Shortcut for Monospaced Formatting in Notes App
- IOS – Excel iOS app: Keyboard shortcut for Edit cell
Best Answer
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.