Highlighting gaps where suppliers have yet to invoice me monthly for

[smerrick]

I have a spreadsheet which shows what months suppliers have invoiced me for. So to make it simple, A1 shows the month we are in (“MMM”), A2 is the header ‘Supplier’ and anything below this will be the supplier name. B2 – M2 are the months Jan – Dec.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Using an example of what I need, if in cell A3 I have a supplier and they invoice me for Jan (recorded in cell B3) , yet we are now in Mar (which would now be stated in cell A1), is there a way to conditional format the cells so that in cell C3 (under the month of ‘Feb’) this would then be automatically highlighted so indicating that we have yet to be invoiced for that month (this cell would show a value of 0)? Once the invoice comes in and the value is then entered for this supplier and month then the cell colour would change back to what it was before (i.e. not formatted). Then when it comes to the next month of ‘Apr’ then any gaps from Jan – Mar would be highlighted, in ‘May’ only cells from Jan – Apr would be highlighted and so on?
<o> </o>
The idea here is to highlight all of the gaps where I have yet to be invoiced for and so to accrue accordingly. Is this problem at all solvable?

 

[onlyadrafter]

Hello,

select the range B3:M (wherever). Select FORMAT --> CONDITIONAL FORMATTING, change CELL VALUE IS to FORMULA IS and enter

=AND(ISBLANK(B3),COLUMN()-1<MONTH($A$1))
as the formula

Is this what you are expecting?

 

[smerrick]

Not quite - the key thing with my example is the month in cell A1 - nothing should be highlighted beyond this month i.e. if we are in 'Mar' nothing from 'Mar' to 'Dec' should be highlighted as we have yet to reach those months. Only 'Jan' and 'Feb'. The same format applies to any other month in cell A1.
Thanks for your attempt though.

 

[onlyadrafter]

Hello,

try this formula

=AND(ISBLANK(B3),MONTH($A$1) > =COLUMN())

without the spaces