For excel 2003:
I currently have a row conditionally formatted to change color of cells "greater than or equal" to the value I entered in a particular cell to green.
I have the same row formatted to also change the cell color to orange of cells "less than or equal' to value of another particular cell.

My problem is that many of the cells in the row are blank, but they are also being changed to orange.

How can I leave blank cells un-formatted? (in other words leave the fill blank?)