G Guest Mar 28, 2005 #1 Cell A1 = due date. Need cell B1 to highlight in color if due date is < today's date. What formula can I use to do this?
Cell A1 = due date. Need cell B1 to highlight in color if due date is < today's date. What formula can I use to do this?
R Ron de Bruin Mar 28, 2005 #2 You can use CF See http://www.contextures.com/xlCondFormat01.html Select B1 Use this formula in CF =A1<today()
You can use CF See http://www.contextures.com/xlCondFormat01.html Select B1 Use this formula in CF =A1<today()
