Forum Discussion
Solved
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 E are the various calls that come in. I'm trying to create a formula that adds a border above an entire row if Column B has a date in it.
I've been having a difficult time trying to find a formula that looks for any data in Column B, and if found, puts a border on that row. Here's what I've done so far:
=SUMPRODUCT(--ISNUMBER(SEARCH("*Friday*",$B2)))
I have one like it for every other weekday. Unfortunately, the formula isn't working. Can anybody assist me in this?
Thank you!!
- Wouldn't something as simple as this work:
=$B2<>""
- Wouldn't something as simple as this work:
=$B2<>""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!
- Nothing, just use this formulas as-is in the condifional format.
