I have an expense manager spread sheet in Microsoft Excel 2010. A row contains (from B2 to AF) sequence of dates(from 1 to 31). How can I write formula field to highlight the current date cell. I tried
Applies To =$A$5:$S$18,
Formula =TODAY() but it does not work.
My excel sheet is look like