I have the folowing 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.