The name of the “Format Cells” text box that appears in the pop-up window changes depending on the rule you select.Type “profit” into that text box and click “OK.” For instance, to cause Excel to highlight any cell that contains the word “profit,” press “Ctrl-A” to select all cells and follow the steps described to navigate to the “Format Cells” text box. Apply this rule to cells, and you can make Excel highlight words that contain text you specify without writing code to perform that task. You may find the “Text Contains” rule useful when working with alphanumeric data.If you copy values from colored cells and paste them into new it new cells, the new cells acquire the color of the copied cell.Apply an If-Then rule to all cells by pressing “Ctrl-A” before assigning your rule.
0 kommentar(er)
