A1VBCode Forums

Excel Formula?


http://www.a1vbcode.com/vbforums/Topic29208.aspx

By Steveclark - 4/26/2010

I want to create a formula or a conditional format in Excel that will allow me to examine a date and see if it is 1 year past the current date. And turn the cell Red. Any help is appreciated.







______________________

Buttons and Triangles in cells
By Newellmyra - 4/28/2010

What you need to do is highlight the cells you want formatted. Then select 'Conditional formatting' from the 'Format' menu. Change your three condition fields to the following:'Cell Value Is' & 'greater than' & '=TODAY()+365'. Make sure the word TODAY is in all capitals. Sometimes Excel will put quotes around the formula, if it does you'll need to delete them.