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

advanced excel seminar training - format

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel seminar training - Format

advanced excel seminar training - Format

ResolvedVersion Standard

Sue has attended:
Excel Advanced course
Access Advanced course
Access VBA course

Format

how do i conditional format

RE: format

Sue

To apply a format condition to a cell or range of cells, first select the range to which you want to apply the format condition, then open the Conditional Formatting dialog from the Format menu.

Next, change the between operation to which ever operation you want. Next, enter the value or values for that condition. Finally, click the Format button on the dialog box. You'll see the standard cell formatting dialog. Not all format items are available in Conditional Formatting. For example, you cannot change the Font or Font Size with Conditional Formatting. Once you have select your format, click the OK button.

hope this answers your question

regards


david

Excel tip:

Adding up rows or columns without seeing formulas

Highlight a column or row and click the Autosum button. This gives you your answer without showing the formula.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.37 secs.