LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
not able to see font color change. luv4bball Excel Discussion (Misc queries) 1 October 30th 06 04:03 PM
Change font colour for whole row Saleee Excel Worksheet Functions 2 October 10th 06 06:41 PM
Change Font Colour and Background If Q [email protected] Excel Worksheet Functions 11 September 27th 06 05:59 PM
font colour change within a IF formula - Help!! Andyp Excel Worksheet Functions 2 August 25th 05 01:17 PM
How do I get the font color to change automatically depending on gtcarlsbad Excel Discussion (Misc queries) 2 February 1st 05 02:39 AM


All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"