conditional formatting help

Select the range of cells you want to format, for example E2:E20. Click Conditional Formatting > New Rule > Use a formula to determine...

Set the formula to:

=E2<TODAY()-365

Click Format... and set the Fill color to Red. Click OK twice.

you could use a formula
=cell with date < TODAY()-365

for 2007 or 2010 excel version
Conditional Formatting

Highlight applicable range >>

the range of cells you want to format


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=cell with date < TODAY()-365


see attached
Format… [Number, Font, Border, Fill]
OK >> OK

Welcome to the Forum DOCSLICE!

Not hard to do but the specific formula depends on how your data is organized. If you have each person in a row with their names in column A, and there is a different certification date in each column with the type of certification in row 1, then your dates start in B2. You will set up conditional formatting in the range B2:X9 where X is the last column and 9 is the last row. You will use a formula to decide which cells to format, and the formula will look like this:

Formula:

=AND(B2=MAX(2:2),B2<DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())))

It will be much easier to understand your problem if you provide your file. This allows us to see your data, layout, and possibly attach a file with a completed solution.

To post a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
3. In the pop-up, click Add then Select to select a file from your local drive
4. Click the Upload button to upload the file
5. Click Done to attach it.

It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.

your welcome

if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.