![]() In the dialog box, select the option: “Use a Formula to determine which cells to format”. I select the first cell within the range, then click on the conditional formatting drop-down, then click on New Rule. You cannot use the techniques that you have learned so far to perform this job. For example, say, I am telling you to format the cells differently that have texts. The range has some values and has some texts. You see a piece of the data range in this worksheet. In this video tutorial and in the next video, we shall learn how you can format cells using formulas. We have used Data bars, Color Scales and Icon Sets to format cells conditionally. We have also learned how to highlight some top or bottom values. ![]() We have used these Greater than, Less than, Between, Equal to, and other formatting rules. We have so far learned how to highlight cells based on the cell content. ![]() You can format any cell using conditional formatting rules. Download Exercise Files, Video Summary & Practice Problems
0 Comments
Leave a Reply. |