Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course - If cell contians text

microsoft excel course - If cell contians text

ResolvedVersion Standard

Wed 11 Jul 2007, 09:21 Delegate Daryl said...

Daryl has attended:
Excel Advanced course

If cell contians text

I have a spreadsheet where I wantr to perform the following

I want to populate cell D80 with the following

Cell C80 I enter text - Yes or No

If I enter Yes I want D80 to = the value (eg

Wed 11 Jul 2007, 09:59 Trainer Amanda said...

RE: If cell contians text

Hi Daryl

Thank you for your question.

Please see the attached file for an example of how this would work - it uses an IF function to enter the result.

Amanda

Attached files...

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