Excel Conditional Formatting: Highlight Cells Rules Explained

A comprehensive tutorial on how to use conditional formatting in Excel. I explain the different options in the Highlight Cells Rules group of conditional formatting, starting with Equal To, demonstrating how to use this to highlight cells with a certain value, before moving on to Text That Contains, which highlights cells containing a specific string of text.

I also demonstrate how to use Greater Than, Less Than, and Between, which are typically used for dates or numbers and after that I show how to clear formatting rules from selected cells or the entire worksheet.

The video concludes with an explanation of how to use Date Occurring to highlight cells containing a specific date. I provide numerous step-by-step instructions and helpful tips throughout the video.

Chapters:

00:00 Introduction
00:44 Equals To
02:40 Text Contains
03:59 Greater than, Less than, Between
05:11 Clearing rules
05:50 Date occurring
06:34 Duplicate values
07:47 TextJoin
09:38 Flash Fill
10:45 Closing remarks

#chrismenardtraining #msexcel

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

#excel #conditionalformatting #chrismenardtraining

[olehchuprynskyi]

Thank you for a great lesson! It's such an unusual solution with the textjoin function! It is really helpful indeed!

Also, thanks for showing the one with "A date occurring...". Before seeing this I always entered the current date in a random cell somewhere in the sheet and compared my list of dates with it.
This option saves lots of time and effort!

Keep up the good work! :)

[advantage_feed]

Hello Chris, thank you for your videos, they really help me to go through my assignments. I have a one question about excel that is not related to this topic. In excel sheets, where on one sheet I have a big table that includes for instance: "products", "profits", and "years", where products and years are duplicated and I need to transfer them on another table on different sheet using a formula to make a list of unique products but at the same time I need the profit of every product for a particular year. So basically I need to sort out years and assign to them profit for the specific product. Thank you for your help. Have a nice day.

[gjaeanne]

Is there a way to highlight a cell based off finding the duplicate and another criteria on another tab?

[laurasoutham]

Hi Chris

I was wondering if you can group multiple names (a team within an organisation) in conditional formatting, so they all appear in one colour, then the next team of people in a different colour. I tried to do this by text and adding multiple names example: John Smith; Paul Jones; Peter Simons but it did not work. Do you have any idea?
Thanks in advance :)

[AshokKumar-hdpz]

Hello Chris,

I am great fan of yours and learned lot of excel formulas by seeing your vedios.

Now i need a help hope you would help me in our office we have a daily tracker in that we have 12 agents and works in 24/7 shifts we work on incident tickets as soon as the ticket arrives we have enter the ticket number in that sheet and change the color of the cell manually according to the time the ticket arrived for eg. if ticket came in between 8am to 9 am it will be green if it is between 9 am to 10 am then red if it is between 10 am to 11 am then purple so on so instead of changing the color manually i need a formula or a steps so based on current time when the data entered into a cell the color should change please suggest


Thanks,
Ashok Kumar B.N