Color a cell if a cell in another Column in the same row has a word

W

wigi

Well-known Member

Joined

Jul 10, 2006

Messages

7,964

Office Version

1. 365

Platform

1. Windows
2. Mobile
3. Web

• Jun 28, 2014

• #2

Select all cells in column B (the one for Monday). For example, the range is B2:B10.
Go to Conditional formatting and set as the formula / condition:

=B2="Host"

give it a color. Add a second condition:

=B2="Co-Host"

and apply a (different) color.

Same for the other days, but the codition will be on columns C, D, and so on.

Be careful to not end up with a spreadsheet that has too many colors: in the end, nothing will take the attention if a lot of cells are colored.

 

Upvote 0

D

DHG BamaBlood94

Board Regular

Joined

Jun 6, 2014

Messages

66

• Jun 28, 2014

• #3

No, what I'm needing is(for example) Me is host for Monday, I need his name(column a) to be a certain color if he is hosting or cohosting. which the word is in column b.

 

Upvote 0

Michael M

Well-known Member

Joined

Oct 27, 2005

Messages

21,835

Office Version

1. 365
2. 2019
3. 2013
4. 2007

Platform

1. Windows

• Jun 28, 2014

• #4

Try this in the CF

Code:

=OR($B$2:$F$2="Host",$B$2:$F$2="Co-Host")

But I think a better option would be, 1 colour for "Host" and another colour for "Co-Host"

Code:

[code]
=$B$2:$F$2="Host"

=$B$2:$F$2="Co-Host"

 

Last edited: Jun 28, 2014

Upvote 0

D

DHG BamaBlood94

Board Regular

Joined

Jun 6, 2014

Messages

66

• Jun 28, 2014

• #5

what kind of CF would it be? text contains?

 

Upvote 0

Michael M

Well-known Member

Joined

Oct 27, 2005

Messages

21,835

Office Version

1. 365
2. 2019
3. 2013
4. 2007

Platform

1. Windows

• Jun 28, 2014

• #6

What version of Excel are you on ??

Use Formula, not cell value

 

Upvote 0

D

DHG BamaBlood94

Board Regular

Joined

Jun 6, 2014

Messages

66

• Jun 29, 2014

• #7

well actually im using google docs, but their so close to the same thing I always came here for the questions and everything has worked

 

Upvote 0

Michael M

Well-known Member

Joined

Oct 27, 2005

Messages

21,835

Office Version

1. 365
2. 2019
3. 2013
4. 2007

Platform

1. Windows

• Jun 29, 2014

• #8

Okay....I'll stick with straight Excel....sorry can't help !!

 

Upvote 0

D

DHG BamaBlood94

Board Regular

Joined

Jun 6, 2014

Messages

66

• Jun 29, 2014

• #9

Nevermind I figured out it wont work with our old google docs. they havent been updated yet.

 

Upvote 0

D

DHG BamaBlood94

Board Regular

Joined

Jun 6, 2014

Messages

66

• Jun 29, 2014

• #10

Thats fine, the only reason I use this site is cause you guys really know what yall are doing, I'm just a basic guy that learnt the basics of excel in school. and I knew google docs were just like excel with a few subtle differences, I guess this is one of them..Thought google docs have updated and implented the formula conditional formatting, our specific sheet hasnt been updated yet. So that's why I couldn't find it. Sorry about the mishap.

 

Upvote 0