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!