Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional formatting

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Conditional formatting

Resolved · Low Priority · Version 2010

Reply Wed 12 Oct 2011, 10:09Delegate Joanne said...

Joanne has attended:
Excel Intermediate course

Conditional formatting

Is it possible to conditionally format two things at once e.g. All of the people that attended a training course and the date attended linked directly to that course

For upcoming training course dates see: Pricing & availability

Reply Fri 14 Oct 2011, 11:32Trainer Anthony said...

RE: Conditional formatting

Hi Joanne, thanks for your query. That certainly is possible, although you'll need to use a formula to do it. Here's a walkthrough of the basics:

http://www.cpearson.com/excel/cformatting.htm

Hope this helps,

Anthony

Fri 21 Oct 2011: Automatically marked as resolved.

Excel articles

· Want To Create A Presentation In Excel?
· Advanced Excel Training - takes you to the next level
· Radio Buttons And Check Boxes In Excel
· Microsoft Excel can ensure you keep on top of your finances
· Find Out How To Create That Missing Link With Excel

Please browse our web site to find out more about
ms excel training and other Microsoft training courses.

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy