Conditional Formatting in ExCel | Change the Colours of the Cells based on its Status Value
📣Agenda of the Video▶️: Use Conditional Formatting to highlight valuable informationℹ️ in Excel.
°OR°,
📣Conditional Formatting in Excel | Play with Colours to Validate Conditions !
-----------------------------------------------------------------------------------------------
👉Learn the steps and the technique.
Here, we are updating "Status" and based on this information "Cell" automatically changes their "Text Colour".
🕵️Follow the shared Steps: -
✍️Select the Entire Table - goto Home🏠Tab - Conditional Formatting - Color Scales - New Rule (New Formatting Rule) - Select a Rule Type - Use a Formula to Determine which Cells to Format - Edit the Rule Description (Format Values where this Formula is True, put the first Condition here) - Select First Text Color, now Repeat 🔁 the same Step for Applying Multiple but Different "Colour" which takes effect on Changing the Cell Status.
🧑💻Set Rules and apply 📊
✅Select the "Cells" that you want to "Conditionally Format".
✅On the Home tab, in the Tables group, click Highlight Cell Rules.
Select the command you want, such as between, Equal to Text that Contains, or a Date Occurring.
✅Enter the values you want to use, and then select a format (fill, text, or border color), and then click OK.
---------------------------------------------------------------------------------------------------------------------------
#conditionalformatting #excel #condition #datasetconditions #formatting #msexcel #microsoft #microsoftexcel #datasets #exceltips&tricks #microsoftlearn
---------------------------------------------------------------------------------------------------------------------------
💥Additional information ℹ️ related with the Short-Video▶️ Creation, are as follows...
🌱Creative ideas💡 Presented By: Team Freelancers.
🌱Content Creator & Speaker Person: Amrit Kaur Saini.
🌱Editor & Publisher: Madhavi Pandey.
🌱Video Editing Software/Tool: Veed.IO
---------------------------------------------------------------------------
This platform has been designed to provide easy solutions via Freelancing to those issues which are related with Dynamics ERPs.
It also includes Vlogging, Discussion on Concept based Scenarios, Online/On-Remote Short Solution for Pre & Post implementation of ERP Software.
We are providing Support Services & Suggestion after Post-Implementation (on pre-payment basis).
------------------- ------------------------ -------------------- ----------------------- --------------------- ------------------ ------------------------------
Here, using this platform, I am trying to provide solution on support related issues. So, why are you waiting for. You all are just a single click away to start learning something new in a different 'n' unique way, with a Freelancer like me!
__________________________________________________________
Freelancing Website🌐: ➡️🔗www.NavisionFunctionalExpert.com
__________________________________________________________
We are publishing 📝Blogs on our Freelancing Website.
To Read the Short-Blog related with Navision & Business Central, visit the Short-Blog Section of the Website.
➡️📝🔗https://navisionfunctionalexpert.com/...
-------------------------------------------------------------------------------------------------------------------------------------