date formula

[dougers1]

Hi There

i am looking for a formula that will tell me when a date has past its 6 month monitoring period

please see attached

Thanks
dougers1

[mcmahobt]

You could try using this as a conditional formatting rule:

Please Login or Register  to view this content.

[Pete_UK]

Select cell A3 (plus others below it if you have more data than just one row), then click on Conditional Formatting | New Rule | Use a Formula... from the bottom of the list, then enter this formula in the dialogue box:

=TODAY()>$B3+182

Click the Format button | Fill tab and choose your colour. You might also want to change the foreground colour on the Font tab to white, and to select Bold to make it stand out even more. Then click OK twice to exit the dialogue box, and Excel will adjust the cell references to suit the pre-selected cells.

Hope this helps.

Pete

[newdoverman]

Give this a try.
Select column B3 down as far as you need, then in Conditional Formatting, New Rule, Use Formula..., enter this formula and apply the formatting that you want:

Please Login or Register  to view this content.

In the Applies to, make sure that the formula is something like this and covers the area you want formatted:

Please Login or Register  to view this content.

[dougers1]

where do i find the applies to

[newdoverman]

The Applies to should will be on the dialogue that shows up after clicking ok after entering the formula and formatting. If it hasn't shown up, click on Conditional formatting, Manage Rules, select workbook and the rule should be there as well as the Applies to information next to the rule.