Days After Month Conditional Formatting

[Philip Wong]

Hi,

I am looking to conditionally format a range of cells if the date is past a specified number of days after the end of the month, i.e. a range of cells which are specified as needing to change on the 1 October as they relate to that date. This would need to take place every month.

Cheers,
Phil

 

[barry houdini]

Hi Philip,

I can't quite work out what you want.

Is 1st October in a cell or do you just want to format according to today's date?