Bottom Line: Learn a technique for applying conditional formatting to the new icons in Excel.
Skill Level: Intermediate
Watch on YouTube and give it a thumbs up.
Download the Excel File
Here are the other posts in the series:
- How to Use the XOR Function
- How to Use XLOOKUP for Reverse Order Search
- Return Multiple Values for a Lookup Formula in Excel with FILTER and UNIQUE
- How to Sort with a Formula in Excel Using SORT and SORTBY Functions
- How to Create a Dynamic Drop-down List that Automatically Expands
- How to Create Icons with Conditional Formatting in Excel (this post)
Bonus: How to Create the Dashboard that is compatible with All Versions of Excel
Very Useful article, Thanks For Sharing With Us
Thanks Chandu! 🙂
Thanks a lot,this is great
Hi Jon,
Thank you for sharing the knowledge.
I would like to seek your help.
I have two separate sheets with subject name,end date and status of medication in common. I need to check if sheet one date for that subject is less than the date on sheet 2 of the same subject but we have to keep in mind that sheet two has 2-3 medication and status of medication as continuing/ stopped.i need to check if sheet 2 has its status of medication as stopped then on sheet 2 also all the medications should be recorded as stopped and date should be equal to or 1day less than sheet 1 date.
Please help in in providing easier way to find out the records for the same.
Thank you once again!
This is fantastic, a lot of helpful tips. Thank you John!