month & year comparison
Posted by Marco on January 31, 2002 6:24 PM
I want to compare the month and year of one cell to others scattered around the worksheet. The first cell, A1, is populated with the TODAY() function. The second cell, B13, is formatted to display only month and year, Mar-02. If the month and year match, I want a conditional format to highlight only those cells that match.
I have worked on this for a few evenings and I do appreciate any help I can get. Thanks in advance!