Hi there

Assuming 2007

If column A is January. I don't know where you have your reference date
i.e. last day of month but how about using A1 in this scenario. Input Jan 31
2010 and then custom format it to mmm. This way it can be your point of
reference and also display the month.

C/F

In A2 - C/F - Manage rules - new rule - Use formula to determine . . - in
the rule description box input =A2A1+15
Format red - ok - ok - Apply - ok

Now use the format painter to the extent of you columns and rows.

Russell Dawson
Excel Student


"Shivam.Shah" wrote:

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
.