Conditional formatting with a cell that concatenates

[tatumrae]

So I have a few columns

Column C = Request Date
Column D = Response Date
Column E (hidden) = difference between Col D and Col C. this has the formula "=IF(D2<>"",D2-C2,"")"
Column F = Response Time. This has the concatenation that says "=CONCATENATE(E2," days")"

Maybe I'm overthinking this, and most likely I am. When I get formulas stuck in my head I can't get rid of them and I'm convinced that I need to use them everywhere.

What I need this to do is have the "Response Time" column tell me the difference between D and C, but only if D has a value. If it is blank, I want nothing to show up in column F.

[ConneXionLost]

How about combining the two:

Please Login or Register  to view this content.

[tatumrae]

How about combining the two:

Please Login or Register  to view this content.

And it was that simple. Knew that I was overthinking it.

THANK YOU!

[tatumrae]

I'm hoping I can get one more question answered on this thread, since it relates to the same formulas.

The code that I was given works. But now I have another condition to throw in there. I need it to also follow the rule that if D2 says "NO RESPONSE", then E2 is blank. If it doesn't contain "NO RESPONSE" then it needs to follow the first condition.

Sorry to sound like such a beginner with this conditional formatting, but it's been awhile since I've dealt with if statements; they really get the best of me!

[tatumrae]

I'm hoping I can get one more question answered on this thread, since it relates to the same formulas.

The code that I was given works. But now I have another condition to throw in there. I need it to also follow the rule that if D2 says "NO RESPONSE", then E2 is blank. If it doesn't contain "NO RESPONSE" then it needs to follow the first condition.

Sorry to sound like such a beginner with this conditional formatting, but it's been awhile since I've dealt with if statements; they really get the best of me!

Figured it out! Thanks for looking.