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.
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.
a | b | c | d | e | |
1 | APRIL 2019 | MAY 2019 | JUNE 2019 | JULY 2019 | |
2 | 03/04/19 | ||||
3 | 07/05/19 | (GREYED OUT) | |||
4 | 06/06/19 | (GREYED OUT) | (GREYED OUT) | ||
5 | 01/08/19 | (GREYED OUT) | (GREYED OUT) | (GREYED OUT) | (GREYED OUT) |