Change the background colour of cell based on text in Excel 2011 for Mac

In this tutorial, we will see the steps required to change the background colour of cell based on text entered in another cell using conditional formatting in Excel 2011 for Mac. Let us considered the following sample data with name of students and their Grade. Now based on the text entered under grade, you want to provide a background colour to the corresponding cells in G,

201405031355.jpg

Step 1: Select cells under column G and and click Conditional Formatting option under Format section.

201405031416.jpg

Step 2: Select Highlight Cells Rules then More Rules from the Conditional Formatting drop down list.

201405031419.jpg

Step 3: In the New Formatting Rules, select Use a formula to determine which cells to format.

201405031421.jpg

Step 4: Now enter the formula as shown below for Grade “A”

201405031436.jpg

Step 5: In the Format with option, select custom format and specify the background colour for the cell. For example, in the above screenshot background colour is set to green.

Step 6: Click OK to confirm and create this rule.

Step 7: Now repeat the steps from 2 to 6 for other grades.

201405031439.jpg

The conditional formatting rules will be applied for all the selected cells. So if you have added a new entry the corresponding grade colour will be automatically populated.

201405031443.jpg

Also See: How to use conditional formatting to to colour alternate rows in Excel 2013

In Category: Apple, Mac, MS Office

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.