I have the following situation:
Today is 4/9/12. I have a cell with a date in the sheet that is 4/13/12. This cell should turn red since it is within 7 days from the current date.
What is a way to use conditional formatting to get Google Spreadsheets to highlight cells that are up to 7 days away from current date?
How can I get the spreadsheet to sort the sheet based on ascending dates in the range I want to sort? I am trying to do this
but all it does is sort all the data including column titles
which is not what I want.