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!

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!

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!

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!

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!

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!