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!