Google Product Forums

Re: Feature request: Conditional Formatting that accepts formulas

FinanceTracker Apr 15, 2012 8:28 PM
Posted in group: Google Docs

Categories: Sheets : Share an idea :

I would also like to see this feature added. I am trying to mimic a spreadsheet I have in excel and would like the ex-dates of Dividends I have coming up in the next month to be highlighted in Green, for example:

if Cell Value is Between =today() and =today() +30

This could also be solved if the team at Google added "in the next month" to the list of rule based conditional formatting options, as opposed to having just prior week/month/year.