Help with spreadsheet Mac Numbers

GoGetGirl

Using spreadsheet to capture dates for when introductory deals end at banks, building societies etc.

Would like to get the 'deal ends' date cell to turn red when I'm within 30 days of the deal ending. Can anyone help please?

GoGetGirl

Thanks Saver0811, I've added the extra column and it now calculates the number of days. Unlike Excel, Numbers insists on adding the letter d after the calculation (presumably to show that its days?). I've found a way to make the cell go red if it relates just to a number but not to one that has a letter after the number. Anyone else out there who knows of a way this in Numbers?

securityguy

GoGetGirl wrote: »

Using spreadsheet to capture dates for when introductory deals end at banks, building societies etc.

Would like to get the 'deal ends' date cell to turn red when I'm within 30 days of the deal ending. Can anyone help please?

Select the cells, and bring up the inspector. Select the "cells" section (marked "42" in a little box). Hit the button marked "Show rules..." in "Conditional Format". Set the rule to "With dates" "in the next" 30 "days", then hit Edit and set the format to be red background (or whatever).

securityguy

Saver0811 wrote: »

This is what I would do, though there may be a more techie way to do what you want.

Numbers directly supports reformatting dates based on where they are in the past or future. See other post.