Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft-excel-training - formatting

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-training - Formatting

microsoft-excel-training - Formatting

ResolvedVersion Standard

Silvia has attended:
Excel Introduction course
Excel Intermediate course

Formatting

how can i colour a cell pink

RE: formatting

Hi Silvia, Thank you for your post, In answer to your question; This is a Formatting option, select the cell you wish to Fill with the colour, you can either click on the Fill button on the Formatting toolbar and choose from the options available, Alternatively, use the Menu command Format, Cells and choose the option Patterns, from the pallet choose the colour you wish to use and click OK. I Hope that helps, best regards Pete.

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes


View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.