Conditional Format a Referenced Cell

Hi,

I have Two sheets, one called Sheet A and one Sheet B.

Sheet A contains exported data (names, employee ID's etc) and sheet B is where I want them displayed in an aesthetically pleasing manner.

I want to be able to conditional format so that if data is present in a cell on Sheet B then it will add a colored background. I can get this to work on Sheet A, but being that Sheet B's cells contain a reference formula, it doesn't consider that cell as blank thus leaving every cell with a background color.

How exactly can I get around this?

Any help would be appreciated!

Sorry about that for the last of a reply. Only just got back into work.

Ok so I have attached the file I am working on.

As you can see on the sheet Personnel Listings, the backgrounds and borders I have in place is how we want the layout to look. All the cells in personnel listings contain cell references to the other sheet. The problem being, this is for customers thus their employee range could be from as little as 5 to as large as 2000. Obviously, the data can be dynamic so I need to have it so that the borders/backgrounds on the cells stop on the row where the last cell has data.

So for example, if the data stops at row 19 then the borders/backgrounds should stop there also. Likewise if it stops at row 1499.

The reason the data is dynamic is due to the other sheet. Information is exported from our software, straight into this excel document

Thanks for any help!

Right, so after having a little play about I managed to find a little work around (adding & " " to the end). It does work, but as you can see in the attached document it looks really quite shocking.

How would I make it so that it will still format all the relevant borders/backgrounds regardless until the it comes across a row that has no data at all?