Q - Use conditional formatting in such a manner that any Cell

which has more than the average for that month will have a green
colour else Red color

January February March April

Jon Allen 10256 12879 14598 16920
Maria Consuelo 11348 21487 25645 33790
Su Li Macado 10987 11987 9587 9454
Tony Jackson 25649 21564 19546 16150
Katie Wilson 20154 22321 18945 19264
Jennifer Flynn 10254 9987 8974 8458
Chi Lyn Cheng 32457 18214 24973 17731
Antonio Bendera 18345 10254 9987 4504
Add arrows to show increase/ decrese in 'nav' as compared
to previous day.
It should look like the image as shown.

fund_symbol price_date nav_per_share

AAAAX 31-Jul-21 10.02
AAAAX 2-Aug-21 9.98
AAAAX 3-Aug-21 10.01
AAAAX 4-Aug-21 9.9
AAAAX 5-Aug-21 9.93
AAAAX 6-Aug-21 9.94
AAAAX 9-Aug-21 10.02
AAAAX 10-Aug-21 9.91
AAAAX 11-Aug-21 9.91
AAAAX 12-Aug-21 9.92
AAAAX 13-Aug-21 9.86
AAAAX 16-Aug-21 9.78
AAAAX 17-Aug-21 9.72
AAAAX 18-Aug-21 9.77
Add Data bars in next column.
It should look like the image as shown.

Product Total rev

BLUECHIP 33236
DB-FLX 77318
DB-VAL 149592
EQ-FLX 212952
EQ-L 148702
EQ-L&MC 172383
EQ-MC&S 17463
EQ-VAL 69550
 Highlight whole row, where date is of 'Today'.

Pax Timeslots for

S.no. Batch Session Dates
Count Training
1 Batch-2 21 3 pm to 7 pm 27/April/2025
2 Batch-1 25 3 pm to 7 pm 12/July/2022
3 Batch-1 24 3 pm to 7 pm 13/July/2022
4 Batch-1 26 3 pm to 7 pm 13/July/2022
5 Batch-1 25 3 pm to 7 pm 14/July/2022
6 Batch-1 25 3 pm to 7 pm 27/April/2025
7 Batch-1 25 3 pm to 7 pm 15/July/2022
8 Batch-1 25 3 pm to 7 pm 15/July/2022
9 Batch-1 25 3 pm to 7 pm 27/April/2025
10 Batch-1 24 3 pm to 7 pm 19/July/2022
11 Batch-1 20 3 pm to 7 pm 20/July/2022
12 Batch-1 20 3 pm to 7 pm 20/July/2022
13 Batch-2 25 3 pm to 7 pm 27/April/2025
14 Batch-3 27 4 pm to 8 pm 21/July/2022
15 Batch-3 26 4 pm to 8 pm 22/July/2022
16 Batch-3 14 3 pm to 7 pm 22/July/2022
17 Batch-1 27 3 pm to 7 pm 26/July/2022
18 Batch-2 24 3 pm to 7 pm 26/July/2022
19 Batch-3 27 4 pm to 8 pm 27/July/2022
20 Batch-1 27 3 pm to 7 pm 27/April/2025
21 Batch-1 28 3 pm to 7 pm 29/July/2022
Trainers
A
B
A
B
A
B
A
B
A
B
A
B
A
B
A
B
A
B
A
B
A
Format whole column with any Color, based on the selection
of month in C5

Month Jan

Jan Feb Mar Apr May Jun

244 605 596 116 970 170
589 385 959 778 1067 419
565 929 685 606 497 591
704 355 1114 686 678 1121
1118 1023 733 998 174 123
1045 1162 819 877 945 1106
681 121 652 993 214 448
666 627 1188 817 530 344
1030 121 384 965 734 1188
645 773 115 362 804 730
697 300 866 377 1184 789

$B7:$G$7=$C$5