Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training class - A short cut to displaying data depending on the date

microsoft excel training class - A short cut to displaying data depending on the date

ResolvedVersion Standard

Thu 26 Apr 2007, 09:44 Delegate Zohra said...

Zohra has attended:
Excel Advanced course
Excel Intermediate course
Excel VBA Intro Intermediate course

A short cut to displaying data depending on the date

Is there another way to display data depending on the date, apart from an if statement with 11 other embedded statements?

Fri 4 May 2007, 10:55 Trainer Tracy said...

RE: A short cut to displaying data depending on the date

Hi Zohara,

Thanks for the question, can you explain what you want to be displayed? There are a number of ways you can customise datas in the Format Cells>Number option but you mention the IF function.

Can you be a little more specific?

let me know and thanks for using the forum

Tracy

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips

microsoft excel training class - A short cut to displaying data depending on the date

A short cut to displaying data depending on the date

RE: A short cut to displaying data depending on the date

Excel articles

Excel tip:

Colouring cells containing formulas