Help using Conditional Formatting to highlight cells that are blank, AND other cell has specific value

[hellscheshirecat]

I am hoping you all can help me with a conditional formatting problem. I'm using Excel 2007 with Windows 7 Pro SP1 OS.

I need to format all the cells in column C, so that if their value is blank AND the value in column G (same row) is equal to the value "child" (without the quotations) the fill color is Red. So for example....

	A	B	C	D	E	F	G
1	SKU	CODE	UPC	BRAND	NAME	COLOR	TYPE
2	123	a1b2c3		Mine	Phone	Black	child
3	546	d4e5f6		Yours	Key	Green	parent
4	789	g7h8i9	000000000000	Ours	Pen	Blue	group
5	1011	j0k1l2	111111111111	His	Pencil	Yellow	collection

<tbody>
</tbody>

So in this example I would need cell C2 to be highlighted red because it is blank and the value in G2 is "child". I know how to use conditional formatting to highlight blank cells but not how to combine it with looking at other cells.

Thanks for all your help!
JC

 

[BenMiller]

Easiest way: Select C2. Go to conditional formatting, select "Formula Is" and type

=(C2="")*(G2="child")

and pick the color red.



Copy C2, highlight the rest of the cells in C, right click>paste special>formats.

 

[Special-K99]

Just use AND

select C1
=(AND(C1<>"",G1="child"))
format as red

Use Format painter to copy the format down the column

 

[Mindpsyche]

I'm pretty sure Ben's works fine but here is another one: =AND($C2="",$G2="child") (Follow his instructions)

 

[hellscheshirecat]

Thank you very very much.

 

[BenMiller]

No problem Glad to help Appreciate the feedback!