Conditional formatting based on dates

Closed
Arwalder - Dec 22, 2014 at 06:29 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Dec 23, 2014 at 11:30 AM
Massive long shot here.....I'm trying to conditionally format certain cells to black out after the end of a certain month.

It is for a monthly time sheet spreadsheet and I have so far been able to get the cells to update to the correct day/date when any date is entered into a particular cell. Eg I enter the date 01/2014 in one cell and then the day if the week and the date shows up in 2 other rows of cells. This works great for when there are 31 days in the month but when the month only has 28 days the dates carry on in to the next month untill the 3rd.
I want to be able to blank out those days that roll over into the next month.
Hope I have explained myself apologies for the rambling message!
Thanks in advance Amy

1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Dec 23, 2014 at 11:30 AM
Hi Amy,

Your query is unclear to me. Can you provide some samples to show how it is now and how you foresee the result.

Best regards,
Trowa

0