Hello all,

This is my first question/post to the board, be easy on me (I searched).

I am trying to figure out a formula that will change the color of a range of cells if they are blank, and if the date is today or earlier.

Right now I have "=ISBLANK(C2:C35)"

Of course this has the desired result of filling only the blank cells, but since it is compiled into a monthly spreadsheet all of the future dates are filled as well. I would like for it to only fill past or current information rather than past/present/future.

Does that change the formula to an "IF" statement?

Thanks,
Matt