Conditional formatting a cell that contains a result from another worksheet

[Triscia]

I have two spreadsheet that are linked together. Sheet 1 contains less data only 4 rows verse the 9 in sheet 2. What I am trying to do is when specific cells contains data in sheet 2 it is copies to specific cells to sheet 1, in sheet 1 if the cells are 0 the cell turns red, if they are greater than 1 then they turn green, if no data has been entered into sheet 2 then sheet 1 remains blank until there date in sheet 2. My problem is I want the cells to be white if there is no data in sheet 1 yet and then turn red and green according to the results, but my conditional formatting turns all the cells green and red if it equals 0. I hope I explain it correctly. Here is my conditional formatting =ISBLANK('Sheet 2'!$E$2:$F$79 will be white (this is my first formula and remains on top, the second is if the cell value on sheet 1 is equal 0 then the cell turns red, if the cell value is greater than or equal 1 it turn cell green. It is in the exact order. TIA!

[mikeTRON]

We can likely help but we need more specifics.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Triscia]

Attached spreadsheet, here is what I am trying to do.

I have two spreadsheet that are linked together. MIA Wkly contains wkly data from only 4 columns verse the 10 in MIA K-1. What I am trying to do is when specific cells/rows contain data in MIA K-1 it is copied to specific cells to MIA Wkly. My conditional formatting for MIA Wkly if the cells are 0 the cell turns red, if they are greater than 1 then they turn green, if no data has been entered into the rest of rows in MIA K-1 then MIA Wkly cells remains blank until there is data in MIA K-1. TIA!