How do I create a keyboard shortcut for conditional formatting for Excel 2011 in OS X? I am unable to find any such shortcut.
- @Buscar웃 Could you explain how I can do so? I am not familiar with themDinesh– Dinesh2015-04-07 16:14:15 +00:00Commented Apr 7, 2015 at 16:14
Add a comment |
2 Answers
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.
-
- This shortcut is a legacy shortcut for Excel 2010 and above in Windows (so that shortcuts from the pre-ribbon days could be used in newer versions). It doesn't apply to the Excel version for macOS.2018-07-02 22:12:16 +00:00Commented Jul 2, 2018 at 22:12
You could use the build in Recorder in Excel 2011. It is called Macro recorder.
Under Tools select New Macro recording. It will record your actions that you can call up with a keyboard short cut that you have chosen.
The result would be something like this pending what you did, and you can recall that any time with your assigned keyboard shortcut.
- But this fixes the rows/cells on which the formatting would be applied. For example, I would like to highlight duplicate selection on rows which I select. I need to repeat this process on different sets of rows. How can I do that?Dinesh– Dinesh2015-04-07 17:32:57 +00:00Commented Apr 7, 2015 at 17:32
- It is meant for repetitive process, it will record your doing, so next time you can use the Macro recording to repeat it. In your case you could have Macro for one set named Macro 1, then have another one named Macro 2 and so on. It will record anything you do, just try it. Or you can do it in one Macro recording, first you select a set of cells (rows) and do conditional, then you select next set of rows and do conditional again.Ruskes– Ruskes2015-04-07 17:53:42 +00:00Commented Apr 7, 2015 at 17:53