Excel Dynamic Conditional Formatting Tricks
Learn and Earn Activity
Now that you have watched the video, its time to practice what you have learned. I cant say often enough if you don’t practice what you learn, you wont remember it in a months time.
So to encourage you and help you become your office Excel Ninja you can earn tokens for completing this activity. Learning Excel has never been more rewarding.
To carry out the learn and earn activity – answer the questions below in the comments section of this post. Rewards will only be given to those that answer the questions here on the blog. No rewards will be given to those that leave comments on Facebook or Youtube.
You can read more about our Learn and Earn Activities here.
Dynamic Conditional Formatting Activity
Copy and paste the following table into Excel
Invoice # | Company | Invoice Date | Invoice Total |
Inv587 | 2 – Company 2 | 30/09/2019 | 2380.05 |
Inv588 | 3 – Company 3 | 01/09/2019 | 3.36 |
Inv589 | 5 – Company 5 | 01/10/2019 | 929.06 |
Inv590 | 2 – Company 2 | 01/10/2019 | 7.8 |
Inv591 | 2 – Company 2 | 01/10/2019 | 102.58 |
Inv592 | 5 – Company 5 | 14/10/2019 | 1346.85 |
Inv593 | 11 – Company 11 | 15/10/2019 | 474.37 |
Inv594 | 11 – Company 11 | 16/10/2019 | 600 |
Inv595 | 9 – Company 9 | 04/10/2019 | 146.52 |
Inv596 | 2 – Company 2 | 10/11/2019 | 837.15 |
Inv597 | 2 – Company 2 | 10/11/2019 | 4.22 |
Inv598 | 1 – Company 1 | 10/11/2019 | 106.37 |
Inv599 | 4 – Company 4 | 16/11/2019 | 88.88 |
Inv600 | 8 – Company 8 | 18/11/2019 | 3513.48 |
Inv601 | 11 – Company 11 | 18/11/2019 | 2490.75 |
Cr500 | 11 – Company 11 | 18/11/2019 | -123 |
Inv602 | 12 – Company 12 | 01/12/2019 | 12300 |
Inv603 | 6 – Company 6 | 01/12/2019 | 12300 |
Create a formula to sum the values of the Invoice Total Column.
Set up conditional formatting to fill every second row of data.
Set up conditional formatting that will put boarders on the cell containing the formula to total the invoice column.
In the comments section below answer the following questions.
- What formula did you use to apply conditional formatting to fill every second row?
- What formula did you use to apply conditional formatting to apply boarders around the cell with the total invoice value?
Do you want to start collecting rewards quickly for learning Excel? Then you should try:
10+ Excel Learn and Earn Activities YOU can do Today
SIGN UP FOR OUR NEWSLETTER TODAY – GET EXCEL TIPS TRICKS AND LEARN AND EARN ACTIVITIES TO YOUR INBOX
Become a Power Pivot Hero
GET and TRANSFORM DATA like a PRO
Power Query Excel 365