![]() ![]() After that, choose a color from the Format > Fill tab and press OK > OK.Here, insert this formula in the Format values where this formula is true box.Next, in the New Formatting Rule dialogue box, select Use a formula to determine which cells to format.Now, go to the Home tab and select Conditional Formatting.First, select cell range B4:D11 where you want to apply the conditional formatting. ![]() In this first process, we will use the SEARCH function to apply conditional formatting and find the required text. Apply Conditional Formatting with Formula Based on Another Text Cell Now, let’s highlight the dataset based on this condition following the methods below. The dataset shows the information of the Annual Transcript of 7 students with their Names, Obtained Marks and Status.įollowing, we inserted the condition Pass in cell C13. To describe the process, we have prepared a dataset here. Conditional Formatting Based on Another Cell Text.xlsxĤ Easy Ways to Apply Conditional Formatting Based on Another Text Cell in Excel
0 Comments
Leave a Reply. |