Conditional formatting based on text from other cell

[roc_ent]

High all, I must be under the influence of the weekend blues because this is just not working for me. What I'm trying to do is to format cells in color based on the text in another cell. So if the text in cell J5 is "Shipped" I want to color format in B5. Then I will drag that conditional formatting down to J102.

 

[Joe4]

Select the range B5:B102, go to Conditional Formatting, and use this formula:

=$J5="Shipped"

and choose your formatting color.

 

[JamesCanale]

MrExcelPlayground2.xlsx
	B	C	D	E	F	G	H	I	J
5									Shipped
6									Silly
7									Shipped
8									Hello
9
10									Shipped
Sheet11

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B5:B16	Expression	=J5="Shipped"	text	NO

 

[Joe4]

Guess I must have posted using "invisible ink" again!