| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement for On One Cell Comparing to the Other Cell
Hello,
I have a column with a text value in it, for example Z01. I need to determine if that value should be in the cell only if a date appears in another cell. The Z01 column is Q and the date that is formatted as m/dd/yyyy is in column M. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement for On One Cell Comparing to the Other Cell
You can not check the value in a cell and then poplulate that cell itself so
you need to enter this in R (or whatever is available) =IF(M1<"",Q1,"") This will check for blank cell M1 and populate with value in Q1 only if it is NOT blank. "Daren" wrote: Hello, I have a column with a text value in it, for example Z01. I need to determine if that value should be in the cell only if a date appears in another cell. The Z01 column is Q and the date that is formatted as m/dd/yyyy is in column M. Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement for On One Cell Comparing to the Other Cell
Thanks, that worked!
"Sheeloo" wrote: You can not check the value in a cell and then poplulate that cell itself so you need to enter this in R (or whatever is available) =IF(M1<"",Q1,"") This will check for blank cell M1 and populate with value in Q1 only if it is NOT blank. "Daren" wrote: Hello, I have a column with a text value in it, for example Z01. I need to determine if that value should be in the cell only if a date appears in another cell. The Z01 column is Q and the date that is formatted as m/dd/yyyy is in column M. Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement for On One Cell Comparing to the Other Cell
Is there a way to use conditional formatting to turn the color red based on
the formula you gave me? Thanks! "Sheeloo" wrote: You can not check the value in a cell and then poplulate that cell itself so you need to enter this in R (or whatever is available) =IF(M1<"",Q1,"") This will check for blank cell M1 and populate with value in Q1 only if it is NOT blank. "Daren" wrote: Hello, I have a column with a text value in it, for example Z01. I need to determine if that value should be in the cell only if a date appears in another cell. The Z01 column is Q and the date that is formatted as m/dd/yyyy is in column M. Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement for On One Cell Comparing to the Other Cell
Yes,
If you want to highlight column Q then Select Col Q Choose Conditonal Formatting Choose Cell Value Is EQUAL To and enter this in the value field ="" (= sign followed by two double quotes) Choose the format you want If it does not work then go back and make sure that Excell has not added "". Remove extra quotes... "Daren" wrote: Is there a way to use conditional formatting to turn the color red based on the formula you gave me? Thanks! "Sheeloo" wrote: You can not check the value in a cell and then poplulate that cell itself so you need to enter this in R (or whatever is available) =IF(M1<"",Q1,"") This will check for blank cell M1 and populate with value in Q1 only if it is NOT blank. "Daren" wrote: Hello, I have a column with a text value in it, for example Z01. I need to determine if that value should be in the cell only if a date appears in another cell. The Z01 column is Q and the date that is formatted as m/dd/yyyy is in column M. Thanks! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement for On One Cell Comparing to the Other Cell
It worked. Thanks!
"Sheeloo" wrote: Yes, If you want to highlight column Q then Select Col Q Choose Conditonal Formatting Choose Cell Value Is EQUAL To and enter this in the value field ="" (= sign followed by two double quotes) Choose the format you want If it does not work then go back and make sure that Excell has not added "". Remove extra quotes... "Daren" wrote: Is there a way to use conditional formatting to turn the color red based on the formula you gave me? Thanks! "Sheeloo" wrote: You can not check the value in a cell and then poplulate that cell itself so you need to enter this in R (or whatever is available) =IF(M1<"",Q1,"") This will check for blank cell M1 and populate with value in Q1 only if it is NOT blank. "Daren" wrote: Hello, I have a column with a text value in it, for example Z01. I need to determine if that value should be in the cell only if a date appears in another cell. The Z01 column is Q and the date that is formatted as m/dd/yyyy is in column M. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing 2 cell updates | Excel Worksheet Functions | |||
| if statement? Want to populate whats in cell or N/A if cell is zer | Excel Worksheet Functions | |||
| Comparing cell contents, know cell address | Excel Discussion (Misc queries) | |||
| Comparing cell contents via VB | Excel Discussion (Misc queries) | |||
| comparing cell | New Users to Excel | |||
Linear Mode
