Highlight cells that contain. Your username will be emailed to the email address on file. Click OK.
Formulas allow you to make more powerful conditional formatting rules... In this example, I want a row to have a gray fill, if Discontinued for the row is set to Yes.
Best regards. Images larger than 600px wide or 1000px tall will be reduced. Now the conditional format only highlights cells that begin with Ann. Thanks for your help. Sign up using Email and Password. There are two ways you can move text using the... Select Use a formula to determine which cells to format.
Help Forgotten Your Password?
See Figure 1. How to highlight rows with conditional formatting.
Here is another situation, I have two columns which the first column contains the text strings and the second column is the specific text, now, I need to highlight the relative text in the first column based on the specific text in the second column. Im gonna search Y in 003.
This elegant technique helps you build killer spreadsheets that are fun to use. However, if you want more flexibility, you can use your own formula, as explained... I am a teacher and have set up a homework tracking sheet. Then press F5 key to run this code, and a prompt box will pop out to remind you enter the text that you want to highlight only, see screenshot:.
B11, and B2 will change to the address of the cell being evaluated each time, since B2 is relative. User Testimonials Customers say. Got a version of Excel that uses the ribbon interface Excel 2007 or later?