Conditional Formatting dependent on whether cell is populated.
 

I want to conditionally format cell G2 dependent upon whether there is a
value in cell C2 AND G2

Therefore,
if cell C2 has a value in it and cell G2 doesn't then cell G2 color = Amber
if cell C2 has a value in it and cell G2 has a value then cell G2 color =
Green

Any helpful hints or useful suggestions?

Thanks

Tel

Conditional Formatting dependent on whether cell is populated.
 

Conditional Format of G2,
condition 1:
=AND(COUNTA(C2)=1,ISBLANK(G2))
format Amber

condition 2:
=COUNTA(C2,G2)=2
format Green
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tel" wrote:

I want to conditionally format cell G2 dependent upon whether there is a
value in cell C2 AND G2

Therefore,
if cell C2 has a value in it and cell G2 doesn't then cell G2 color = Amber
if cell C2 has a value in it and cell G2 has a value then cell G2 color =
Green

Any helpful hints or useful suggestions?

Thanks

Tel

Conditional Formatting dependent on whether cell is populated.
 

Depends what you mean by "a value". Is the null string "" a value in your
terms?
CF/ Formula Is/ =AND(C2<"",G2="") for Amber [or
=AND(NOT(ISBLANK(C2),ISBLANK(G2))]
Either modify the above for your Green condition, or =COUNTA(C2,G2)=2
--
David Biddulph

"Tel" wrote in message
...
I want to conditionally format cell G2 dependent upon whether there is a
value in cell C2 AND G2

Therefore,
if cell C2 has a value in it and cell G2 doesn't then cell G2 color =
Amber
if cell C2 has a value in it and cell G2 has a value then cell G2 color =
Green

Any helpful hints or useful suggestions?

Thanks

Tel

Conditional Formatting dependent on whether cell is populated.
 

Excellent, thank you

Tel

"Luke M" wrote:

Conditional Format of G2,
condition 1:
=AND(COUNTA(C2)=1,ISBLANK(G2))
format Amber

condition 2:
=COUNTA(C2,G2)=2
format Green
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tel" wrote:

I want to conditionally format cell G2 dependent upon whether there is a
value in cell C2 AND G2

Therefore,
if cell C2 has a value in it and cell G2 doesn't then cell G2 color = Amber
if cell C2 has a value in it and cell G2 has a value then cell G2 color =
Green

Any helpful hints or useful suggestions?

Thanks

Tel