hellscheshirecat
New Member
- Joined
- Jul 24, 2012
- Messages
- 12
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....
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]SKU
[/TD]
[TD]CODE
[/TD]
[TD]UPC
[/TD]
[TD]BRAND
[/TD]
[TD]NAME
[/TD]
[TD]COLOR
[/TD]
[TD]TYPE
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]123
[/TD]
[TD]a1b2c3
[/TD]
[TD][/TD]
[TD]Mine
[/TD]
[TD]Phone
[/TD]
[TD]Black
[/TD]
[TD]child
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]546
[/TD]
[TD]d4e5f6
[/TD]
[TD][/TD]
[TD]Yours
[/TD]
[TD]Key
[/TD]
[TD]Green
[/TD]
[TD]parent
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]789
[/TD]
[TD]g7h8i9
[/TD]
[TD]000000000000
[/TD]
[TD]Ours
[/TD]
[TD]Pen
[/TD]
[TD]Blue
[/TD]
[TD]group
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]1011
[/TD]
[TD]j0k1l2
[/TD]
[TD]111111111111
[/TD]
[TD]His
[/TD]
[TD]Pencil
[/TD]
[TD]Yellow
[/TD]
[TD]collection
[/TD]
[/TR]
</tbody>[/TABLE]
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
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....
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]SKU
[/TD]
[TD]CODE
[/TD]
[TD]UPC
[/TD]
[TD]BRAND
[/TD]
[TD]NAME
[/TD]
[TD]COLOR
[/TD]
[TD]TYPE
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]123
[/TD]
[TD]a1b2c3
[/TD]
[TD][/TD]
[TD]Mine
[/TD]
[TD]Phone
[/TD]
[TD]Black
[/TD]
[TD]child
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]546
[/TD]
[TD]d4e5f6
[/TD]
[TD][/TD]
[TD]Yours
[/TD]
[TD]Key
[/TD]
[TD]Green
[/TD]
[TD]parent
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]789
[/TD]
[TD]g7h8i9
[/TD]
[TD]000000000000
[/TD]
[TD]Ours
[/TD]
[TD]Pen
[/TD]
[TD]Blue
[/TD]
[TD]group
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]1011
[/TD]
[TD]j0k1l2
[/TD]
[TD]111111111111
[/TD]
[TD]His
[/TD]
[TD]Pencil
[/TD]
[TD]Yellow
[/TD]
[TD]collection
[/TD]
[/TR]
</tbody>[/TABLE]
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