| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| not able to see font color change. | Excel Discussion (Misc queries) | |||
| Change font colour for whole row | Excel Worksheet Functions | |||
| Change Font Colour and Background If Q | Excel Worksheet Functions | |||
| font colour change within a IF formula - Help!! | Excel Worksheet Functions | |||
| How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
Linear Mode
