Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting dependent of preceding cell | Excel Discussion (Misc queries) | |||
How to set a conditional format that is dependent on cell type | Excel Discussion (Misc queries) | |||
conditional number format dependent on other cell | Excel Discussion (Misc queries) | |||
Conditional Formatting dependent on another cell | Excel Discussion (Misc queries) | |||
Data Validation - Dependent Lists & Conditional Formatting | Excel Worksheet Functions |