Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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 2007

Reply Wed 8 Sep 2010, 16:42Delegate Sarah said...

Sarah has attended:
Excel Intermediate course

Conditional Formatting

I would like to know more about using conditional formatting on dates.

For upcoming training course dates see: Pricing & availability

Reply Wed 8 Sep 2010, 20:21Trainer Newson said...

RE: Conditional Formatting

Hi

Sarah

I know you wanted to condtionally format rows based on dates could you describe an example of what you want to do or send me a mock spreadsheet.

You can e-mail me at newson.

Thanks

Newson

Reply Wed 8 Sep 2010, 20:23Trainer Newson said...

RE: Conditional Formatting

Sarah

If you have an example of a spreadsheet that you want to conditionally format send it to me at newson

If you can describe what you want to do in words with eg. reply to this post

Many thanks

My first reply was not clear

Thanks

Newson

Reply Fri 17 Sep 2010, 12:33Trainer Nafeesa said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 23 Sep 2010: Automatically marked as resolved.

Excel articles

· Preparing to Pivot: Why all Excel users should know about Pivot Tables
· Chart Creation Simplified - in 4 Simple Steps
· That's The Wonder Of Autofill
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· A Brief Glimpse At Excel's What If Analyses Tools

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

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips