IF Statement for On One Cell Comparing to the Other Cell

  • Thread starter Thread starter Daren
  • Start date Start date
D

Daren

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!
 
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.
 
Thanks, that worked!

Sheeloo said:
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.
Click to expand...
 
Is there a way to use conditional formatting to turn the color red based on
the formula you gave me? Thanks!
 
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...
 
It worked. Thanks!

Sheeloo said:
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...
Click to expand...
 
Back
Top