Format background color

Hi, i have an excel i am modelling in power.

I need to set conditional formatting in power bi based on the following rules,


I know i have to set it here but i cant figure out the right way

Thanks for your help

Hello @wilford.mitchell AYODEJI QUADRI OSANYIN,

To improve your skills in using Conditional Formatting in Power BI when migrating from Excel to Power BI, the following documentation and videos are helpful.

Documentation

• Microsoft Learn: Apply conditional formatting in tables and matrixes
• Chandoo: How to conditionally format visuals in Power BI?
• SQL Shack: Conditional formatting in Power BI
• Hevodata: Power BI Conditional Formatting: The Ultimate How-To Guide
• SQLBI: Highlighting the minimum and maximum values in Power BI matrix
• SPGuides: Power BI Conditional Formatting Based On Field Value

Video Training

• EnterpriseDNA: Custom Conditional Formatting Techniques In Power BI
• EnterpriseDNA: How To Use Conditional Formatting Based On String Fields - Power BI February 2023 Updates
• MyOnlineTrainingHub: Power BI Conditional Formatting Tables Inside Out - Including Custom Icons and URLs
• Alex The Analyst: How to use Conditional Formatting in Power BI | Microsoft Power BI for Beginners
• Power BI Guy: Row Based conditional formatting in Power BI
• Reid Havens: New Way to Apply Conditional Formatting by Category in Power BI!

Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a like.