Agenda of the Video▶️: Use Conditional Formatting to highlight information in Excel.br -----------------------------------------------------------------------------------------------br Learn the steps and the technique. br Here, we are updating "Status" and based on this information "Cell" automatically changes their "Text Colour".br br ️Follow the shared Steps: -br ✍️Select the Entire Table - goto HomeTab - 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.br br ‍Set Rules and apply br br ✅Select the "Cells" that you want to "Conditionally Format".br br ✅On the Home tab, in the Tables group, click Highlight Cell Rules.br Select the command you want, such as between, Equal to Text that Contains, or a Date Occurring.br br ✅Enter the values you want to use, and then select a format (fill, text, or border color), and then click OK.