Change font colour
 

I have a speadsheet containing a column of dates which related to a
second column in which there is a formula working out an expiry date.
I havent used VBA before and was hoping someone could help me write a
macro that changes the column with the expiry dates to RED if the date
is TODAY or after.
Any assistance appraciated!

Change font colour
 

Take a look Conditional Formatting in Help menu

" wrote:

I have a speadsheet containing a column of dates which related to a
second column in which there is a formula working out an expiry date.
I havent used VBA before and was hoping someone could help me write a
macro that changes the column with the expiry dates to RED if the date
is TODAY or after.
Any assistance appraciated!

Change font colour
 

VBA not needed!! Here's a short demo

A1 = 10/15/2006 (a true date, not text)
B1 = 60
C1 = =A1+B1 (which displays 12/14/2006)

With C1 the current cell, Click (on the menu) Format,
Conditional Formatting, Select CellValueIs, then select
Less than or equal to, then in empty box type in: =today()
Then Click the Format button, Pattern, your color, and OK OUT..

C1 should be in the color you selected

Now change Cell B1 to 75

C1 should be Clear (No Color).

Does that help?



" wrote in message
ups.com:

I have a speadsheet containing a column of dates which related to a
second column in which there is a formula working out an expiry date.
I havent used VBA before and was hoping someone could help me write a
macro that changes the column with the expiry dates to RED if the date
is TODAY or after.
Any assistance appraciated!

Change font colour
 

That worked a treat....thanks for your prompt reply :-)


JMay wrote:

VBA not needed!! Here's a short demo

A1 = 10/15/2006 (a true date, not text)
B1 = 60
C1 = =A1+B1 (which displays 12/14/2006)

With C1 the current cell, Click (on the menu) Format,
Conditional Formatting, Select CellValueIs, then select
Less than or equal to, then in empty box type in: =today()
Then Click the Format button, Pattern, your color, and OK OUT..

C1 should be in the color you selected

Now change Cell B1 to 75

C1 should be Clear (No Color).

Does that help?



" wrote in message
ups.com:

I have a speadsheet containing a column of dates which related to a
second column in which there is a formula working out an expiry date.
I havent used VBA before and was hoping someone could help me write a
macro that changes the column with the expiry dates to RED if the date
is TODAY or after.
Any assistance appraciated!