Count days and color them in a calendar

  • Thread starter Thread starter portREMOVEengine
  • Start date Start date
P

portREMOVEengine

I'm looking at the calendars that Chip and Vertex 42 have thoughtfully
created. I like both but now I'd like to find a way to count an event
that occurs every six days and then color or mark that date.

It would be something like an Outlook event that you can set to occur
every six days but instead of a reminder appearing, just have the date
appear differently than all the others.

I'd like to do this in Excel because I don't have Outlook at every
computer that I have access to. Thanks in advance for any guidance you
can give.
 
Presuming the cell has a date, you can use conditional formatting with a
formula of

=MOD(A1-DATE(YEAR(TODAY()),1,0),6)=0

just change the =0 to the correct value to get the correct day formatting.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Looks like those fields aren't set as date like you mentioned. It seems
to be only a number in that cell. When I entered the formula for
conditional formatting it would only change the colors for that one
cell.
 
Which one cell? This seems something new.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top