Formulas Tags: Office Formula Spreadsheet Apps Last response: March 11, 2011 9:44 PM in Applications Share Genna January 21, 2011 12:00:45 PM I am working on a spreadsheet and need to create a formula so that in the following instances the cell is highlighted: If the date in cell A <= Today + 180 days AND The date in cell B <=A + 90 days. Then Cell 'A' will be highlighted. I am not sure if this is possible. Can anyone offer a solution? More about : formulas mosox March 11, 2011 8:04:31 PM Try in here http://www.excelforum.com/excel-2007-help/ Maybe this helps too http://www.softpedia.com/get/Office-tools/Other-Office-... Anonymous March 11, 2011 9:44:17 PM This topic has been moved from the section Windows 2000/NT to section Applications by Grumpy9117 Can't find your answer ? Ask ! Publish Related resources: ForumExcel 2007 formulas ForumSmart People: Can anyone come up with any formulas for water cooling? ForumFormulas ForumWho has formulas for Fatom paint colors? ForumIV formulas ? ForumSpreadsheet formulas insufficient Forumformulas in excel Forumfailure of formulas in Excel ForumConverting decimals to time formula needed ForumOck ASUS FORMULA IV - PHENOM 1090T ForumASUS Blitz Formula BIOS Failure ForumHow to write a Formula ForumHow good is on-board sound for Maximus Formula V? ForumWhat is the difference between Extended and normal version of a software? More resources Read discussions in other Applications categories Graphics Internet Applications Multimedia Office Security CAD Distributed Computing Drivers Enterprise Software Firmware Programming Photoshop Skype Wordpress !