Method for Excel 2010 For Excel 2010, right-click on the cell that contains the conditional formatting to move to other cells. Click Copy from the pop-up menu.

Helen Bradley demonstrates Excel formatting tricks that will help you when things don't work as planned. Learn her methods now.

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.