On Thu, 28 Jul 2005 03:23:03 -0700, "blackadder"
wrote:

I want to change the colout of a cell once the current date has passed

Select your cell.

From the top menu bar:

Format/Conditional Formatting

Cell Value Is less than =TODAY()

Select Format and decide on your formatting.


--ron