IF statement help. If Adjacent cell is empty then..

Hi guys!

(see attached)

I'm wondering if anyone can help with an IF statement problem I'm working on.

I'm dealing with 2 worksheets here. The destination worksheet (attached) and a primary worksheet (attached) where the destination sheet is pulling from.

I'd like the text in column B (i.e."Upstairs" and "Exterior") on the destination sheet to become bold IF, on the primary sheet, there is no content (or an empty cell) in the adjacent cell.

Please let me know if you have any suggestions or if I can clarify anything.

Thanks!

@ lightofchaos, Conditional Formatting does not work (yet) across files.

@ wizzle, you could probably do this by pulling in teh data from the promary WB into hidden columns, and then basing teh CF on that. (apart from VBA, Conditional Formatting is teh only way to make cells formatting change, based on other values)

Also, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

Hi
It's a Conditional Formatting formula, it's not placed in the cells. See attached image.

CF dialogue Screenshot.jpg

Select the range of cells and Conditional formatting 'New Rule'.