REWORLD COMPUTER ORGANIZATION

ADVANCE EXCEL

CONDITIONAL FORMATTING

1. Highlight the highest and lowest sales within the week (Highest Sales-Green fill color , lowest
sales – red fill color)
Day Sales
Sunday 8000
Monday 9000
Tuesday 2500
Wednesday 10000
Thursday 12000
Friday 7800
Saturday 9500

2. Highlight the date with red fill color which is Sunday or Saturday and others day yellow fillcolor
and highlight the sales value which is greater than average sales of 15 days

Date sales amount

4/1/2023 5000
4/2/2023 5400
4/3/2023 4800
4/4/2023 5200
4/5/2023 6000
4/6/2023 3200
4/7/2023 4000
4/8/2023 6500
4/9/2023 5200
4/10/2023 5800
4/11/2023 5700
4/12/2023 5400
4/13/2023 1200
4/14/2023 5600
4/15/2023 5500
3. Highlight the cell blue fill color having std code “033” and highlight the name having title “das”
cell value having
Phone No name
033-25781227 robin das
033-25771234 Rohit kumar
011-23217771 kunal das
011-22212010 kartick das
022-22123303 kaonlon bera

4. Highlight the name with fill color-yellow uppercase name, highlight the name fill color- green
lowercase name

DEPARMENT
Highlight the salary lowest and highest salary NAME SALARY NAME
robin das 5000 SALES
Rohit kumar 9000 PURCHASE
KAMAL DAS 4000 SALES
KUNTAL KUNDU 5800 SALES
kaonlon bera 6000 PURCHASE
5. Highlight the duplicate phone no. in the list phone no bill amount
Highlight the bill amount not between 500 to 1000 9945632422 400
amount 9895632482 500
9945632422 600
8445634521 900
3945632488 700
9945632422 500
7890132423 200
9945632433 300
9945632422 400
9945644466 250
9456324212 235
9945632422 457
6. Highlight the name who score 1st, 2nd , 3rd (using large and rank function)
TOTAL
ROLL NAME
MARKS
1 RAM 321
2 SAM 540
3 JODU 547
4 MODHU 512
5 GOPAL 250
6 HORI 690
7 ALEX 774
8 ROBIN 350
 7. Highlight the student id who not paid subscription also highlight student id who paid
subscription in different fill color

student_id subscription
not paid
a001 200 subcription
a002 300 student_id
a003 400 a001
a004 250 a003
a005 320 a004
a006 410 a007
a007 250 a009
a008 300
a009 450

8. Highlight the employee name who work less than 300 day in the company
Highlight date of birth using the following condition
Age <25 years fill with blue color
Age between 26 to 50 years fill with yellow color
Age>50 years fill with red color

employee details 2022 list of

date of birth holydays
employee name joining date release date
1/26/2021
RAM 2/1/2000 1/1/2021 5/10/2022
5/2/2021
SAM 5/12/1999 1/1/2021 2/3/2022
8/15/2021
JODU 6/1/1975 1/1/2021 4/2/2022
12/25/2021
MODHU 3/12/2000 1/1/2021 9/2/2021
1/26/2022
GOPAL 5/26/1998 1/1/2021 4/15/2022
5/2/2022
HORI 7/1/1987 1/1/2021 8/12/2021
8/15/2022
ALEX 6/7/1960 1/1/2021 9/9/2022
12/25/2022
ROBIN 1/1/1984 1/1/2021 8/8/2022

9. Highlight the number which is perfect square number 4 is perfect square(2 x 2), 9 (3 x 3)
22 3 4 9 12