Hi I have a large excel spreadsheet to track lots of mandatory training which needs to be retaken periodically i.e. 01/02/2009 due to retake 2 years later 01/02/2011 and I want to make the original dates turn red once the set period has passed. I have tried conditional formatting but have not used it much in excel 2007 and it seems less flexible unless you know the exact formatting styles which I don't

Can you help?

Conditional Formatting is much more flexible in 2007 and later versions. What do you mean by

"unless you know the exact formatting styles"?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Conditional formating gives you set options under a number of headings for greater than, less than etc. and there is an option to add new rules but I can't figure out what formula(s) I need to add to make the cell go red if the date entered in the spreadsheet is greater than the refresher period set. I have tried IF statements, TODAY statements but can't figure it out.

The only thing a Conditional Formatting rule needs to format a cell is a formula that returns TRUE. Test your formulas in a cell and when you find one that returns TRUE for the conditions you need, use it as a Conditional Formatting rule.

Give us some examples of your conditions and we'll see if we can help.

BTW...most Excels users have been taught to use IF statements in Conditional Formatting. You don't always have to.

For example, when comparing A1 to B1, many users will use:

=IF(A1>B1, TRUE, FALSE)

All that is really needed is:

=A1>B1

This will return TRUE when A1 > B1 and the Conditional Formatting will be applied.

Try =A1>B1 in a cell and see what it returns.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll