Copy and paste conditional formatting to other cells
http://office.microsoft.com/en-in/excel-help/copy-and-paste-conditional-formatting-to-other-cells-HA102809448.aspx
If you’ve used a conditional format and want to apply it to new or other data on your worksheet, you can use Format Painter to copy the conditional formatting to that data.
- Click the cell that has the conditional formatting you want to copy.
- Click Home > Format Painter.
The pointer changes to a paintbrush.
Tip You can double-click Format Painter if you want to keep using the paintbrush to paste the conditional formatting in other cells.
- To paste the conditional formatting, drag the paintbrush across the cells or ranges of cells you want to format.
- To stop using the paintbrush, press Esc.
0 Response to "Mengambil niali dari rumus excel"
Post a Comment