Conditional Format

[surkdidat]

I know this should be simple, but my head won't work this out!
In Row 1 I have months
In Column A I have dates of work started
What I need is conditional format to "grey out" the cell if the date in column A is before the start date of the month

So if the date was 02/04/19 it will leave the April column blank,
if it was 2 May 2019, it would grey out April, but leave May 2019 blank,
if it was June, then both April and May would be greyed out etc.

[table="width: 500, class: Grid, align: Center"]
[tr]
[td][/td]
[td]a[/td]
[td]b[/td]
[td]c[/td]
[td]d[/td]
[td]e[/td]
[/tr]
[tr]
[td]1[/td]
[td][/td]
[td]APRIL 2019[/td]
[td]MAY 2019[/td]
[td]JUNE 2019[/td]
[td]JULY 2019[/td]
[/tr]
[tr]
[td]2[/td]
[td]03/04/19[/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]3[/td]
[td]07/05/19[/td]
[td](GREYED OUT)[/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]4[/td]
[td]06/06/19[/td]
[td](GREYED OUT)[/td]
[td](GREYED OUT)[/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]5[/td]
[td]01/08/19[/td]
[td](GREYED OUT)[/td]
[td](GREYED OUT)[/td]
[td](GREYED OUT)[/td]
[td](GREYED OUT)[/td]
[/tr]
[/table]

 

[Fluff]

What are the actual values in B1,C1 etc?

 

[surkdidat]

These are purely column headers with the dates of the month. Effectively they will be 01/04/19 01/05/19 01/06/19 etc

What are the actual values in B1,C1 etc?

 

[tyija1995]

A custom rule would work, highlight the region you want to apply to then open a new CF rule and put:

=AND(MONTH($A2)>MONTH(B$1),YEAR($A2)>=YEAR(B$1)) --> Format with however you choose (greyed pattern style would be ideal under fill tab on format cells)

EDIT: Taken into account of the year too incase month piles over to following year.

 

[tyija1995]

Apologies, that doesn't quite work as intended after some further testing...

Try:
=AND($A2>B$1,OR(MONTH($A2)>MONTH(B$1),YEAR($A2)>YEAR(B$1)))

 

[Fluff]

Select B2 to the end of data & use
=$A2>EOMONTH(B$1,0)