I am trying to set a sheet in which some cells have dates entered. I want the background colour to change when todays date is 30 days or less than the date in the cell and another colour when todays date is after the date in the cell. I am assuming htis could be done by conditional formatting.
Is it possible to make the cell flash if todays date is after the date in the cell?
Is it possible to make the cell flash if todays date is after the date in the cell?