![]() For example, format blank cells, or see which salespeople are selling above average, or track who has received birthday greetings from you. In Excel, use formulas in conditional formatting to do more than you can with the built-in rules. The inspiration spreadsheet (attached) utilizes a 2 variable data table and conditional formatting, where the cells are formatted based on their value in relation to a variable called 'Gross'. ![]() I'm trying to reverse engineer a spreadsheet (see attached) and apply the data table to my own spreadsheet. 2.In the New Formatting Rule dialog box, click Use a formula to determine which. ![]() Please do as follows: 1.Select the text list that you want to highlight the cells which contain partial text, and then click Home > Conditional Formatting > New Rule, see screenshot. In fact, the Conditional Formatting in Excel can help you to highlight the cells if contain partial text as quickly as you need. She wanted to know if she could use Conditional Formatting to color a cell based on the contents of another cell. Today I got an interesting question from a customer using Excel for Mac 2011. (For those who are curious, I am using Excel 2010 for Mac) I want Cell B2 to be green when A2 says 'John likes green apples' and B2 also says 'John likes green apples', yellow if A2 says 'John likes green apples' and B2 says 'Bill likes blue apples', and red if A2 says 'John likes green apples' and B2 says 'Bill hates red oranges'.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |