Forum home » Delegate support and help forum » Microsoft Excel Training and help » training in excel - Conditional formatting

training in excel - Conditional formatting

ResolvedVersion Standard

Mon 12 Mar 2007, 16:18 Delegate Waheena said...

Waheena has attended:
Excel Introduction course
Excel Intermediate course

Conditional formatting

can you use words in conditional formatting?

Mon 12 Mar 2007, 16:31 Trainer Richard said...

RE: conditional formatting

Yes, but only an exact word

ie: and

NOT

John and Mary

Tue 13 Mar 2007, 12:45 Delegate Louise said...

RE: conditional formatting

to ensure that your or other users only use exact words (as even a trailing space wouldn't work) use it in combination with data --> validation which can supply a little pulldown list of text to choose from.

Data validation is also useful for other times when words must be very exact, like with SumIf.

Thu 22 Mar 2007, 13:41 Trainer Richard said...

RE: conditional formatting

Thanks for that Louise

Microsoft Excel training

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010

Here's how to move or copy sheets between workbooks in Excel 2010:

Open the sheet you want to move or copy then on the Ribbon click the Home tab. Click Format. Under Organize Sheets, select the option Move or Copy Sheet and then choose where you want the sheet to be moved/copied to.

View all Excel hints and tips

training in excel - Conditional formatting

Conditional formatting

RE: conditional formatting

RE: conditional formatting

RE: conditional formatting

Excel articles

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010