conditonal 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 » Conditonal formatting

Conditonal formatting

resolvedResolved · Low Priority · Version 2007

Warwick has attended:
Excel Advanced course

Conditonal formatting

How Do I clear conditional formating from a column?

RE: Conditonal formatting

Select the column in question. Go to the Home Ribbon and select conditional formatting. From the dropdown select Clear Rules and select clear rules from Selected Cells.

Fri 2 Jul 2010: Automatically marked as resolved.


 

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips


Server loaded in 0.08 secs.