High Lighting Cells Depending on Text inserted.

**Rhiannon25** · 04-02-2013, 11:11 PM

Hi Everyone

Basically what I would like to happen on my spreadsheet, is that I have a list of 12 people in Column H (H21 to H32) when you enter a name into column D, i want the cell to turn green if it matches a name on that list (H21 to H32), and red if the name does not appear on the list.Reward Scratchies Tracking Spreadsheet Example.xls

I beleive that this can be done through conditional formatting but just not 100% sure on the formula. I have attached a spreadsheet if needed.

Any Help would be appreaciated.

Thanks

Rhiannon

**:) Sixthsense :)** · 04-02-2013, 11:38 PM

Place the cursor in C2 cell and extend the selection below and Press Alt+O+D>>Formula Is

Use This Formula to Mark It as Green

Formula:

=COUNTIF($H$21:$I$32,$C2)

Click Add Condition
Use This Formula to Mark It as Red

Formula:

=AND(TRIM($C2)<>"",COUNTIF($H$21:$I$32,$C2)=0)

**Rhiannon25** · 04-03-2013, 12:00 AM

Thank-you that worked perfectly

**:) Sixthsense :)** · 04-03-2013, 12:02 AM

Glad it helps you and thanks for the feedback

High Lighting Cells Depending on Text inserted.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

High Lighting Cells Depending on Text inserted.

Re: High Lighting Cells Depending on Text inserted.

Re: High Lighting Cells Depending on Text inserted.

Re: High Lighting Cells Depending on Text inserted.

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions