Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate cell is another cell is populated
I need to populate a cell if another cell is populated. In other words, if
A2 or B2 or C2 are not null, then put "Orange" in cell D2. Then if Cell D2 is populated and cell E2 is not populated, then I want to put "Please enter a color" in cell F2 and highlight cell E2 in red. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate cell is another cell is populated
in D2 enter: =IF(A2&B2&C2<"","Orange","")
in F2 enter: =IF(AND(D2<"",E2=""),"Please enter a color","") set conditional format for E2 to Formula: =$E$2="" and set pattern color. "jhicsupt" wrote: I need to populate a cell if another cell is populated. In other words, if A2 or B2 or C2 are not null, then put "Orange" in cell D2. Then if Cell D2 is populated and cell E2 is not populated, then I want to put "Please enter a color" in cell F2 and highlight cell E2 in red. Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate cell is another cell is populated
Try this in D2:
=IF(AND(A2="",B2="",C2=""),"","Orange") NOW ... what happens if D2 *AND* E2 is populated? What happens if D2 is null and E2 is populated? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jhicsupt" wrote in message ... I need to populate a cell if another cell is populated. In other words, if A2 or B2 or C2 are not null, then put "Orange" in cell D2. Then if Cell D2 is populated and cell E2 is not populated, then I want to put "Please enter a color" in cell F2 and highlight cell E2 in red. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for a cell which is blank returns populated cell | Excel Discussion (Misc queries) | |||
How do I hide a row in excel if a certain other cell is populated | Excel Worksheet Functions | |||
auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
Index heading when cell is populated | Excel Worksheet Functions | |||
Check to see if a cell is populated | Excel Worksheet Functions |