Scribd
Upload
4 views11 pages

Conditional Formatting Exercise

The document contains four tasks: highlighting dates after October 6, 2018, identifying grades above average, finding duplicate names, and selecting cells greater than the median of a range. Each task is presented with a list of relevant data. The document also includes tips for calculations and reminders about dynamic references.

Uploaded by

jannatulishra26
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
4 views11 pages

Conditional Formatting Exercise

The document contains four tasks: highlighting dates after October 6, 2018, identifying grades above average, finding duplicate names, and selecting cells greater than the median of a range. Each task is presented with a list of relevant data. The document also includes tips for calculations and reminders about dynamic references.

Uploaded by

jannatulishra26
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

1 Highlight all the dates after October 06, 2018:

Date
11/3/2018
5/11/2019
12/3/2018
9/26/2019
4/12/2018
1/3/2019
5/6/2018
6/21/2019
7/24/2019
4/22/2018
6/8/2019
10/17/2017
1/28/2018
3/19/2019
8/18/2019
10/19/2017

2 Highlight all grades above average:

Grades
59
56
75
99
86
72
89
67
76
80
71
56
63
100
100

3 Highlight all the duplicate names:

John
Danny
Dean
Donny
Jake
Jill
Hannah
Jake
John
Danny
Dean

4 Highlight all cells greater than the MEDIAN of the range:

79
59 Median: 78
60
78
87
88
71
78
99
54
57
95
55
91
76
79
1 Highlight all the dates after October 06, 2018:

Date
11/3/2018
5/11/2019
12/3/2018
9/26/2019
4/12/2018
1/3/2019
5/6/2018
6/21/2019
7/24/2019
4/22/2018
6/8/2019
10/17/2017
1/28/2018
3/19/2019
8/18/2019
10/19/2017

2 Highlight all grades above average:

Grades
59
56
75
99
86 Check yourself:
72 76.6 =AVERAGE(B34:B48)
89
67
76
80
71
56
63
100
100
3 Highlight all the duplicate names:

John
Danny
Dean
Donny
Jake
Jill
Hannah
Jake
John
Danny
Dean

4 Highlight all cells greater than the MEDIAN of the range:

79 Tip:
59 Use Median Function to calculate the Medi
60
78 Check yourself:
87 78 =MEDIAN(B85:B100)
88
71
78
99
54
57
95
55
91
76
79
n Function to calculate the Median

=MEDIAN(B85:B100)
Please note -
Don't use reference on Cell B85! It has to be dynamic!

You might also like