Month: September 2024
Retrieval Augmented Fine Tuning: Use GPT-4o to fine tune GPT-4o mini for domain specific application
Customization is key!
One of the most impactful applications of generative AI for businesses is to create natural language interfaces that have been customized to use domain and use case specific data to provide better, more accurate responses. This means answering questions about specific domains such as banking, legal, and medical fields.
We often talk about two methods to achieve this:
Retrieval Augmented Generation (RAG): Storing those documents in a vector database and, at query time, retrieving documents based on their semantic similarity to the question, then using them as context for the LLM.
Supervised Fine-Tuning (SFT): Training an existing base model on a set of prompts and responses representing the domain-specific knowledge.
While most organizations experimenting with RAG aim to extend an LLM’s knowledge with their internal knowledge base, many do not achieve the expected results without significant optimization. Similarly, it can be challenging to curate a sufficiently large and high-quality data set for fine-tuning. Both approaches have limitations: fine-tuning confines the model to its trained data, making it susceptible to approximation and hallucination, while RAG grounds the model but retrieves documents based merely on their semantic proximity to the query — which may not be relevant and can lead to poorly reasoned answers.
RAFT to the rescue!
Instead of choosing RAG or fine-tuning, we can combine them! Think of RAG as an open book exam: the model looks up relevant documents to generate answers. Fine-tuning is like a closed book exam: the model relies on pre-trained knowledge. Just like in exams, the best results come from studying and having notes handy.
Retrieval Aware Fine-Tuning (RAFT) is a powerful technique to prep fine-tuning data for domain-specific open-book settings, like in-domain RAG. It’s a game-changer for language models, combining the best parts of RAG and fine-tuning. RAFT helps tailor models to specific domains by boosting their ability to understand and use domain-specific knowledge. It’s the sweet spot between RAG and domain-specific SFT.
How does it work?
RAFT has three steps:
Preparing a dataset to teach the model how to answer questions about your domain.
Fine tuning a model with your prepared dataset
Evaluating the quality of your new, custom, domain adapted model
The key to RAFT is the training data generation, where each data point includes a question (Q), a set of documents (Dk), and a Chain-of-Thought style answer (A).
The documents are categorized into Oracle Documents (Do), which contain the answer, and Distractor Documents (Di), which do not. Fine-tuning teaches the model to differentiate between these, resulting in a custom model that outperforms the original with RAG or fine-tuning alone.
We use GPT-4o to generate training data and fine-tune GPT-4o mini, creating a cost-effective, faster model tailored to your use case. This technique, called distillation, uses GPT-4o as the teacher model and 4o-mini as the student.
In the next section of this blog, we’ll get hands on. If you want to follow along on your own, or see reference code, check out https://aka.ms/aoai-raft-workshop. We’ll create a domain adapted model for a banking use case, capable of answering questions about a bank’s online tooling and accounts.
Notebook 1- Generating your RAFT training data
Start by gathering domain-specific documents; in our example, these are PDFs of bank documentation. To generate our training data, we convert the PDFS to markdown text format The document is in PDF format and contains a number of tables and charts, we will use GPT-4o to convert the pages content to markdown. We use Azure OpenAI GPT 4o to extract all of this information into a Markdown file to be used for downstream processing. We then use GPT-4o (our teacher model) to generate synthetic Question-Document-Answer triplets including examples of “golden documents” (highly relevant) and “Distractors” (misleading). This will ensure the model learns to differentiate between relevant and irrelevant information. RAFT utilizes Chain of Thought (CoT) process, by integrating CoT RAFT process improves the model’s ability to extract information and perform logical reasoning. This method helps prevent overfitting and enhances training robustness, making it particularly effective for tasks that require detailed and structured thinking
We then format this data for fine-tuning, splitting it into training, validation, and test sets. The validation data is used during training, and the test set measures performance at the end.
Now it’s time to teach our student! After preparing the training and validation data, the next step is to upload this data to Azure OpenAI and create the fine-tuning job. This is surprisingly easy: in AI Studio, selecting your model, uploading your training and validation data, and setting your training parameters are just a few clicks. We’ll select 4o-mini as our student model for training. In the lab we will show you how to use the SDK to upload and trigger the fine-tuning job. UI makes it an easy way to experiment, and SDK approach is preferred way for productionalizing and enabling your llmops strategy for deploying in production.
Once the fine-tuning job is running, we can monitor its progress and, upon completion, analyze the fine-tuned model in Azure OpenAI Studio. Finally, we create a new deployment with the fine-tuned model, ready to be used for our specialized domain tasks.
Notebook 3 – Is our RAFT model really better than the base model? Let’s check!
You can start off by reviewing the built in metrics returned by AI Studio, showing loss and accuracy. We want to see accuracy increase, while loss goes down:
However – we can do much more to measure the quality of our model. Remember our test dataset from the beginning? This is why we prepared it!
While there are many options for evaluation, including AI Studio evaluations, in our example we use the open-source library RAGAS, which evaluates RAG pipelines with metrics like answer relevancy, faithfulness, answer similarity, and answer correctness. These metrics rely on either an LLM as a judge or an embedding model to assess the quality and accuracy of the generated answers.
We could probably improve our metrics further by adjusting our training parameters and/or generating additional training data to improve model metrics.
Ready to get started yourself?
Access Azure AI Studio today: https://oai.azure.com/
Learn more about fine tuning and customization: https://learn.microsoft.com/en-us/azure/ai-services/openai/tutorials/fine-tune?tabs=python-new%2Ccommand-line
Follow along with the code: https://aka.ms/raftworkshop
Acknowledgement:
This Hands-On Lab was heavily inspired by Cedric Vidal and Suraj Subramanian excellent blogs: https://aka.ms/raft-blog , https://aka.ms/raft-recipe-blog-datagen and https://aka.ms/raft-recipe-blog-ft and reference implementation: https://aka.ms/raft-repo
Credit to Liam Cavanagh for the inspiration of using GPT-4o to convert the pages content to markdown
Credit to Cedric Vidal for helping review the blog and lab
References:
[2006.05525] Knowledge Distillation: A Survey (arxiv.org) https://arxiv.org/abs/2006.05525
RAFT: Adapting Language Model to Domain Specific RAG https://arxiv.org/html/2403.10131v1
RAFT: A new way to teach LLMs to be better at RAG https://techcommunity.microsoft.com/t5/ai-ai-platform-blog/raft-a-new-way-to-teach-llms-to-be-better…
Berkeley researchers published blog post outlining the benefits and drawbacks of DSF and RAG, and demonstrating how the RAFT approach can deliver more effective results. Their implementation of RAFT is available on GitHub
Microsoft Tech Community – Latest Blogs –Read More
Office365 imap issue
While configuring IMAP, We are getting below errors attached in the screenshots.
The PHP INI file has “IMAP” enabled.
Our passwords are correct.
While configuring IMAP, We are getting below errors attached in the screenshots. The PHP INI file has “IMAP” enabled. Our passwords are correct. Read More
W3CIISLogs high data ingestion
Hi
We have a log analytics workspace in the production environment where we have high data ingestion happening for the W3CIISLogs because of which the cost has been increasing. The daily ingestion is around 70GB. I am trying to figure out if there are any ways to reduce the data ingestion of IIS logs inorder to reduce cost
One of the way i know is to filter out the schema and keep only the required ones, but since this is production we may need to keep ,majority of schema. Not looking for any Commitment purchase.
Can someone please let me know if there are other ways to reduce the data ingestion?
HiWe have a log analytics workspace in the production environment where we have high data ingestion happening for the W3CIISLogs because of which the cost has been increasing. The daily ingestion is around 70GB. I am trying to figure out if there are any ways to reduce the data ingestion of IIS logs inorder to reduce costOne of the way i know is to filter out the schema and keep only the required ones, but since this is production we may need to keep ,majority of schema. Not looking for any Commitment purchase. Can someone please let me know if there are other ways to reduce the data ingestion? Read More
Az-firewall-mon(itor) – near real time Azure Firewall flow log analyser
Hello, networking expert! I’m excited to share with you an update on my personal open source project: az-Firewall-mon: Az-firewall-monitor is an open-source tool that helps you answer to the following question: what is happening in my azure Firewall right now?
It provides an alternative and opinionable way to access and inspect Azure Firewall logs, without using Log Analytics or Kusto queries. It provides a simple and intuitive interface that shows you what is happening on your firewall right now (or almost).
to filter your data you can use both a full text search or natural language thanks to his integration with chatGPT4.
Here a sample full text search interaction:
here a sample natural language interaction
Try out az-firewall-monitor at https://az-firewall-mon.duckiesfarm.com or have a look at the source code on GitHub at https://github.com/nicolgit/azure-firewall-mon
Thank you!
Hello, networking expert! I’m excited to share with you an update on my personal open source project: az-Firewall-mon: Az-firewall-monitor is an open-source tool that helps you answer to the following question: what is happening in my azure Firewall right now? It provides an alternative and opinionable way to access and inspect Azure Firewall logs, without using Log Analytics or Kusto queries. It provides a simple and intuitive interface that shows you what is happening on your firewall right now (or almost).to filter your data you can use both a full text search or natural language thanks to his integration with chatGPT4.Here a sample full text search interaction: here a sample natural language interaction Try out az-firewall-monitor at https://az-firewall-mon.duckiesfarm.com or have a look at the source code on GitHub at https://github.com/nicolgit/azure-firewall-monThank you! Read More
How to Install Microsoft conected cache on on-premis server
I want to start delivery optimization for our company using Intuin and see how to install the Microsoft-connected cache on my server on-premise so that the updates can be downloaded from local devices instead of directly from the net or peer-to-peer from other devices. Also, we don’t have a configuration manager.
I want to start delivery optimization for our company using Intuin and see how to install the Microsoft-connected cache on my server on-premise so that the updates can be downloaded from local devices instead of directly from the net or peer-to-peer from other devices. Also, we don’t have a configuration manager. Read More
Best way to get Copilot for custom training sessions
Hi everyone
I need to deliver a custom Copilot for Microsoft 365 course and require Copilot for Microsoft 365 licenses for the attendees. I need about 10 licenses.
What’s the best way to get Copilot for Microsoft 365 licenses for the training session?
Regards
Chintan Patel
Hi everyone I need to deliver a custom Copilot for Microsoft 365 course and require Copilot for Microsoft 365 licenses for the attendees. I need about 10 licenses. What’s the best way to get Copilot for Microsoft 365 licenses for the training session? RegardsChintan Patel Read More
Missing remediation actions
Hi everyone,
Remediation actions such as Disable/Enable user in AD, Force password reset are currently not available through the Defender portal (user page, advanced hunting). Anyone aware of this change?
https://learn.microsoft.com/en-us/defender-for-identity/remediation-actions#supported-actions
Hi everyone, Remediation actions such as Disable/Enable user in AD, Force password reset are currently not available through the Defender portal (user page, advanced hunting). Anyone aware of this change? https://learn.microsoft.com/en-us/defender-for-identity/remediation-actions#supported-actions Read More
Prblem trying to email out payslips
Your email provider is stating 0025 REPLY : 504 5.7.4 Unrecognized authentication type [LO4P123CA0679.GBRP123.PROD.OUTLOOK.COM 2024-09-25T09:12:25.177Z 08DCDCE3BE51AF33] You would need to contact whoever looks after your email account or your email provider to find out why that would be the case
Your email provider is stating 0025 REPLY : 504 5.7.4 Unrecognized authentication type [LO4P123CA0679.GBRP123.PROD.OUTLOOK.COM 2024-09-25T09:12:25.177Z 08DCDCE3BE51AF33] You would need to contact whoever looks after your email account or your email provider to find out why that would be the case Read More
Return Sharepoint search results in external site’s search engine
Hey, This is a general question, and sorry if I am not using the right technical terms 😕 We have this SharePoint site that is used as our intranet, where official documentation is stored. We have this other platform for forums and conversations, and we would like to be able to return SharePoint search results (from our intranet) when a user searches for terms in this external tool. So the idea would be to create some sort of federated search that would include SP as one of its sources of results. Is this something that can be done? Are there any setting up guidance anywhere or examples of this working? Cheers,J Read More
Teams Bot Feedback button is not shown to most of the user
Hello everyone,
I developed a Teams chatbot which used Azure Search and Azure OpenAI. For chatbot response which has citations from Azure Search, I enabled the feedbackLoop
response.ChannelData = new { feedbackLoopEnabled = true };
It was a success. I can see the thumbs up/down button and managed to capture the feedback.
Unfortunately, some of the users reported that they can’t see the thumbs up/down button in Desktop Teams or Teams Web. Strangely, if they use their Android Teams App, they can see the thumbs up/down button.
Anyone knows what could be the reason for such a strange behavior?
Thanks in advance.
Regards,
Hardono
Hello everyone, I developed a Teams chatbot which used Azure Search and Azure OpenAI. For chatbot response which has citations from Azure Search, I enabled the feedbackLoop response.ChannelData = new { feedbackLoopEnabled = true }; It was a success. I can see the thumbs up/down button and managed to capture the feedback. Unfortunately, some of the users reported that they can’t see the thumbs up/down button in Desktop Teams or Teams Web. Strangely, if they use their Android Teams App, they can see the thumbs up/down button. Anyone knows what could be the reason for such a strange behavior? Thanks in advance. Regards,Hardono Read More
Permissions – How to restrict the deletion?
Dear Community
I want my team to be able to add tasks and not be able to delete them. This will prevent anyone from deleting tasks.
How can I do this?
From the list of tasks, I can granularly restrict the tasks, meaning that TEAM 1 will see some tasks and not all of them.
Thank you in advance
Dear Community I want my team to be able to add tasks and not be able to delete them. This will prevent anyone from deleting tasks. How can I do this?From the list of tasks, I can granularly restrict the tasks, meaning that TEAM 1 will see some tasks and not all of them.Thank you in advance Read More
Developer Tenant External User Messaging Issue
Hi everyone
I have a Microsoft 365 Developer Tenant which includes 25 Microsoft 365 E5 Developer licences. I have been messaging a friend who is external to this tenant and it has been working fine up until around 2 weeks ago. Having looked into it, this seems to have coincided with Microsoft enforcing the policy to block federation with Teams trial-only tenants.
Am I right in thinking that my developer tenant is considered a trial-only tenant in this instance?
Hi everyone I have a Microsoft 365 Developer Tenant which includes 25 Microsoft 365 E5 Developer licences. I have been messaging a friend who is external to this tenant and it has been working fine up until around 2 weeks ago. Having looked into it, this seems to have coincided with Microsoft enforcing the policy to block federation with Teams trial-only tenants. Am I right in thinking that my developer tenant is considered a trial-only tenant in this instance? Read More
cannot open recently saved file
This morning, I saved an excel file then closed. When I went to the folder, the only file showing is the OLD version from a few days ago. When I do a search by modified date, the file appears on the list. But when I click on the file, only the old version is opening. Why?#
The new file is nowhere to be “found” — well, it’s showing up on my search but opening it is another issue, as only the old file is opening.
This morning, I saved an excel file then closed. When I went to the folder, the only file showing is the OLD version from a few days ago. When I do a search by modified date, the file appears on the list. But when I click on the file, only the old version is opening. Why?#The new file is nowhere to be “found” — well, it’s showing up on my search but opening it is another issue, as only the old file is opening. Read More
MS Teams / Nur-Sultan (Astana, Kazakhstan) timezone and city name isn’t up to date
Hello,
I have some problems in both Teams for Business and Personal Teams
First of all, the city is called Astana, not Nur-Sultan (https://www.theguardian.com/world/2022/sep/14/kazakhstan-to-change-name-of-capital-from-nur-sultan-back-to-astana).
Secondly, on December 7, 2023, the Kazakh Ministry of Trade and Integration proposed that Kazakhstan switch to a single time zone in 2024. Specifically, Kazakhstan would uniformly apply the fifth time zone (UTC+5) across its entire territory. On March 1, 2024, the cities of Astana, Almaty, and Shymkent, as well as the following regions, will turn back the local time by one hour: Abai, Akmola, Almaty, Zhambyl, Zhetisu, Karagandy, Kostanai, Pavlodar, North Kazakhstan, Turkistan, Ulytau, and East Kazakhstan (https://techcommunity.microsoft.com/t5/daylight-saving-time-time-zone/interim-guidance-for-kazakhstan-time-zone-changes-2024/ba-p/4048963).
Currently, the time zone for Astana is UTC+5, but in MS Teams, it still shows UTC+6.
Please address this issue.
Looking forward to your response
Best regards,
Nikita.
Hello,I have some problems in both Teams for Business and Personal TeamsFirst of all, the city is called Astana, not Nur-Sultan (https://www.theguardian.com/world/2022/sep/14/kazakhstan-to-change-name-of-capital-from-nur-sultan-back-to-astana).Secondly, on December 7, 2023, the Kazakh Ministry of Trade and Integration proposed that Kazakhstan switch to a single time zone in 2024. Specifically, Kazakhstan would uniformly apply the fifth time zone (UTC+5) across its entire territory. On March 1, 2024, the cities of Astana, Almaty, and Shymkent, as well as the following regions, will turn back the local time by one hour: Abai, Akmola, Almaty, Zhambyl, Zhetisu, Karagandy, Kostanai, Pavlodar, North Kazakhstan, Turkistan, Ulytau, and East Kazakhstan (https://techcommunity.microsoft.com/t5/daylight-saving-time-time-zone/interim-guidance-for-kazakhstan-time-zone-changes-2024/ba-p/4048963).Currently, the time zone for Astana is UTC+5, but in MS Teams, it still shows UTC+6.Please address this issue.Looking forward to your responseBest regards,Nikita. Read More
How do you fix iPhone stuck on white screen with apple logo on my Windows 11?
My iPhone has recently encountered a problem. It has been stuck on a white screen with an Apple logo. No matter how I restart it, it is useless and I can’t enter the system at all. I use a Windows 11 computer. I tried to connect my phone to the computer and use iTunes to restore the system, but it didn’t seem to work. In this case, is the system crashed or is there a problem with the hardware? Has anyone encountered a similar situation and know how to solve it? It’s really urgent. My phone is completely unusable now. Please help!
My iPhone has recently encountered a problem. It has been stuck on a white screen with an Apple logo. No matter how I restart it, it is useless and I can’t enter the system at all. I use a Windows 11 computer. I tried to connect my phone to the computer and use iTunes to restore the system, but it didn’t seem to work. In this case, is the system crashed or is there a problem with the hardware? Has anyone encountered a similar situation and know how to solve it? It’s really urgent. My phone is completely unusable now. Please help! Read More
DISABELING ‘Details Pane’ for a SharePoint list?
Hi,
for a SharePoint list (with some action triggers to start PowerAutomate flows) I have created different panes via PowerApps for collecting input for a new request with a NewForm and a version to Edit the form EditForm.
In the created list view (see screenshot) I do not show ALL the input fields from the NewForm, some are confidential (they are usable for me in the background when I collect the inputs from this list in a PBI report).
However, now it turns out ALL info filled on the NewForm can always be seen via the details pane!?!? how can we disable this???
Can the details pane also be edited with the help of PowerApps?
best regards
Jeroen
Hi, for a SharePoint list (with some action triggers to start PowerAutomate flows) I have created different panes via PowerApps for collecting input for a new request with a NewForm and a version to Edit the form EditForm. In the created list view (see screenshot) I do not show ALL the input fields from the NewForm, some are confidential (they are usable for me in the background when I collect the inputs from this list in a PBI report). However, now it turns out ALL info filled on the NewForm can always be seen via the details pane!?!? how can we disable this??? Can the details pane also be edited with the help of PowerApps? best regardsJeroen Read More
Azure Arc – SQL Server instances – Error SqlServerDatabases_Update
Hi, I’ve been getting intermittent errors on the SQL section of Arc for a few days now.
Also the section becomes inactive for me; then for a few minutes it seems to get back up and running and then it becomes inactive again; do any of you have similar problems?
For the machine management part via Arc, on the other hand, no problem.
Hi, I’ve been getting intermittent errors on the SQL section of Arc for a few days now. Also the section becomes inactive for me; then for a few minutes it seems to get back up and running and then it becomes inactive again; do any of you have similar problems?For the machine management part via Arc, on the other hand, no problem. Read More
Where are downloads?
I have a SQL Server 2022 Web Edition licence provided by my hosting company and I’m trying to download the correct version to install on a dedicated server to be used in production. I go to https://www.microsoft.com/en-gb/sql-server/sql-server-downloads, but the only on-premise option is to register for a free trial version, which I understand should not be used in production.
Can I install this and apply the licence to it? Or is there a different source for the full version?
I have a SQL Server 2022 Web Edition licence provided by my hosting company and I’m trying to download the correct version to install on a dedicated server to be used in production. I go to https://www.microsoft.com/en-gb/sql-server/sql-server-downloads, but the only on-premise option is to register for a free trial version, which I understand should not be used in production. Can I install this and apply the licence to it? Or is there a different source for the full version? Read More
Managing your organization’s brand with the SharePoint brand center
The SharePoint brand center introduces a central location for your organization to manage and create brand assets for Microsoft 365. The new Brand center brings together the power of your organization asset libraries and your organization’s brand assets to create and manage product application of your brand into Microsoft 365 products.
Our new SharePoint brand center provides an easy-to-use location for your brand managers (individuals responsible for your organizations brand) to create and manage from a single location. While today’s brand center is primarily focused on SharePoint and Viva Connections, we are excited to be working with multiple teams across Microsoft 365 to integrate their services for organization brand with the brand center and will share a bit more on this topic in this document.
Features and capabilities mentioned in this blog post, are demonstrated in the following video with Cathy Dew (Microsoft) and Vesa Juvonen (Microsoft).
Manage your organization’s brand assets
The Brand center is setup to allow easy management of your organization assets that will be available across Microsoft 365 in one location while also providing a location to create product specific brand application scenarios. The first of these organization assets to be supported in the brand center are brand fonts and brand colors.
Brand fonts
Manage your organization’s brand fonts using the brand fonts library in the SharePoint brand center. As a brand manager uploads your font files into the brand fonts library you will be able to manage which fonts are available in picker experiences. Fonts can be used to define and showcase your brand’s expression.
Brand colors
Manage your organization’s brand colors using the brand color list in the SharePoint brand center. As a brand manager, you can create a list of your brand colors that will be available for picker experiences. Brand colors can be utilized to customize and add personality to your content and experiences.
Learn more about brand colors.
Brand images
Images and logos can provide the context, definition, and identity of your content to align with your brand. By utilizing Organization Assets Libraries brand managers can provide the images to help anyone in their organization create content that will reflect the values and beliefs of their brand.
Learn more about setting up organization asset libraries
SharePoint and Viva Connections Branding
Font packages
Once you have uploaded your organizations brand fonts into the SharePoint brand center, you will be able to create a font package that can later be applied to your SharePoint sites and Viva Connections desktop experiences. A font package contains the configuration of how you want your fonts to be utilized within your content.
Microsoft has provided a set of 8 font packages that can be used without uploading custom fonts into the Brand center to transform your sites and experiences.
You can include 2 font families into your font package and then select 4 font styles to assign to the font package slots. Headline, title, content, and interactive will determine which fonts and styles are used in your content.
SharePoint includes custom font support for the following areas (September 2024):
Site header – site title
Quick links web part
Hero web part
All web part titles (From Microsoft)
Link web part
Hub header – hub title
Button web part
Sites web part
Countdown timer web part
Organization chart web part
Navigation (hub and site) – links and labels
Dashboard for Viva Connections
People web part
Events web part
Site activity web part
News web part
Image web part
Call to action web part
Highlighted content web part
Weather web part
Page title region
Section heading
Text web part (RTE)
Image gallery web part
World clock web part
Viva Connections includes custom font support for the following areas:
Welcome/Greeting text
Section headings
Dashboard cards Level 1
Resources
You can also utilize custom fonts in your custom solutions using SharePoint Framework.
Learn more about font packages.
Themes
Using color can transform the look of your sites and experiences and we are excited to introduce a new way to create and manage themes within the SharePoint brand center. You can use this new tool to create your organization’s themes without needing PowerShell. Any existing themes created in your tenant via PowerShell will remain available and manageable with PowerShell.
Creating themes in the SharePoint brand center will make these themes available for your organization to use in the Change the look experience.
Learn more about themes in SharePoint and Viva Connections.
PowerPoint branding
Copilot in PowerPoint using your organization’s brand library
When working with Copilot and PowerPoint you have two options to utilize your organization’s brand content in your presentations.
By using Copilot with your organization’s branded templates, you can create presentations that look tailored for your information. Copilot will try it’s best to create beautiful presentations with your content, but by following the best practices outlined in the linked documentation you will have the best chance to be successful.
Learn more about using organization brand templates with Copilot and PowerPoint
Once you have a presentation or if you are creating a presentation on your own and would like to use your organization’s images you can also make use of Copilot to select images. With a few simple steps, you can ask Copilot to find images from your organization with a simple conversation.
Learn more about enterprise images with Copilot for PowerPoint
Clipchamp branding
Brand kits in Clipchamp
When creating video content Clipchamp makes it easy to provide all of your organization’s brand assets in one simple package called a Brand kit. It is now possible to create brand kits for your organization and distribute them to your enterprise users.
Learn more about brand kits in Clipchamp.
We look forward to seeing what you create with the SharePoint brand center and your organization’s brand assets across Microsoft 365.
Microsoft Tech Community – Latest Blogs –Read More
Conditional Formating / Double condition not working (with dates)
Good morning/afternoon/night,
I’m trying to apply the double condition formatting in Excel, but it is not working, while apply separately it is working … which is Strange.
My custom formula is :
=and(I$2<=$B3;$B3<I$1)
You can see in the screenshot bellow that the intersection is good on I3 and O4 but they’re not yellow, not sure what I am missing here. Any clue ?
Good morning/afternoon/night,I’m trying to apply the double condition formatting in Excel, but it is not working, while apply separately it is working … which is Strange.My custom formula is : =and(I$2<=$B3;$B3<I$1) You can see in the screenshot bellow that the intersection is good on I3 and O4 but they’re not yellow, not sure what I am missing here. Any clue ? Read More