Format based on data and date...

**90G60** · 11-19-2012, 02:17 PM

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

**dogberry** · 11-19-2012, 02:20 PM

Hi

Use your conditional formatting for that if you are not sure post a sample to be amended.

Chris

**:) Sixthsense :)** · 11-19-2012, 02:25 PM

Hi 90G60,

Welcome to the forum.

The formula =ISBLANK(C2) should be used in single cell reference and you can use it for range of cells if you are using it with some other function with array notion.

Some more details are required for giving exact solution for your query so please post a sample workbook by explaining the expected outcome with cell or row references.

**90G60** · 11-19-2012, 02:47 PM

Sorry, still new to posting these on the forums. So for now I will use screen shots.

In the first screen shot you can see that there are two cells filled as they are blank. This is what I am going for. What I am hoping to fix is that when applied to the workbook it formats all of the future dates since they are blank (as it hasn't happened yet).

It is really just an annoyance, it doesn't actually harm anything.

11-16.jpg

11-20.jpg

Thanks again!