Forum Discussion
Brandon Kennedy
Jan 29, 2018Copper Contributor
Conditional Formatting based on Separate Column
Good morning, everyone,
I'm trying to create a formula for a spreadsheet that is utilized as a phone log. Column B is the Date, which I only enter the date one time per day. Columns C through...
- Jan 29, 2018Wouldn't something as simple as this work:
=$B2<>""
Brandon Kennedy
Jan 29, 2018Copper Contributor
Thank you for the quick response. I'm not very familiar with Excel equations. Can you tell me what information, if any, I would be putting in the <> and in the ""?
Thank you!
JKPieterse
Jan 29, 2018Silver Contributor
Nothing, just use this formulas as-is in the condifional format.
- Brandon KennedyJan 29, 2018Copper Contributor
That did it, thank you! I marked your answer as Best Answer.
I appreciate your help!
- JKPieterseJan 29, 2018Silver Contributor
You're welcome!