View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shivam.Shah Shivam.Shah is offline
external usenet poster
 
Posts: 12
Default Colouring cell if it has a specific date

Hi,

I have a column for each month where the dates are entered on rows. Is
it possible I can color a cell if the date entered in a cell for that
month is 15 days past the end of the month. Like, if in a January
column I enter a date on one of the rows as Feb.20, then the cell
fills with red colour.

I tried doing it using conditional formatting, but don't know how to
say 15 days past end of the month?

Any help will be appreciated! Thanks very much!

Shivam