Highlight cell based on day of the month

[lorenambrose]

Hey all,

I have a worksheet with a column called day. It is 31 rows long. The cells are formatted as TEXT "01" through "31".

I want to conditionally format the cell based on the day of the month. If it is the 15th day of the month, then highlight the cell with "15" in it.

I thought it would be easy enough, but since this is not actually a calendar and is divorced from the month and year, it is proving to be very challenging.

Thanks,
Loren

 

[kevin9999]

Something off with the entire column. I deleted the column and recreated it and now it is working.

Good to hear you got it working