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
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 :)
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! :)
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.
Copy the worksheet. Now use Excel's remove duplicates feature. It is located on the Data tab. Now create a PivotTable and put the Years field in the Rows, Product in rows or columns, and Profit in the value area.
Microsoft Teams online training with Chris Menard chrismenardtraining.teachable.com/p/microsoft-teams?coupon_code=50-PERCENT-OFF
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
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 :)
Is there a way to highlight a cell based off finding the duplicate and another criteria on another tab?
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! :)
You're very welcome! Thanks, Oleh.
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.
Copy the worksheet. Now use Excel's remove duplicates feature. It is located on the Data tab. Now create a PivotTable and put the Years field in the Rows, Product in rows or columns, and Profit in the value area.