microsoft excel training day courses near kent - conditional formatting

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - Conditional formatting

microsoft excel training day courses near kent - Conditional formatting

resolvedResolved · Low Priority · Version Standard

Andrew has attended:
Excel Advanced course

Conditional formatting

How do I conditional format a cell and then drag it down to other cells beneath it?

RE: Conditional formatting

Hi Andrew

Thank you for your question.

There are a couple of different ways of copying conditional formatting from one cell and applying it to other cells.

Option 1 is to select a cell that has the conditional formatting already applied to it, then click the Format Painter button (looks like a paint brush) on the Standard toolbar. Then highlight the cells you want to apply the conditional formatting to.

Option 2 is to select a cell that has the conditional formatting already applied to it, then Copy the cell. Then highlight the cells you wish to apply the conditional formatting to, go to Edit - Paste Special, choose Formats and click OK.

I hope this helps.
Amanda


 

Excel tip:

Copying the same value, label or formula quickly into a range of selected cells.

Select your range of cells. Type the value, label or formula that you want to appear in all the selected cells and then press Ctrl+Enter.

View all Excel hints and tips


Server loaded in 0.1 secs.