If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
colour change of dated box
How can I change the colour of a dated box of excel after the date is over. I
want the programme to read date automatically from pc and change colour. |
#2
|
|||
|
|||
colour change of dated box
try Conditional Formatting
In 2003: 1. Select the cells you want to format 2. Choose Format, Conditional Formatting 3. Choose Cell Value Is from the first drop down 3. Choose Formula is from the first drop down 4. Choose less than 5. In the third box, enter =TODAY() 6. Click the Format button 7. Choose a color on the Patterns tab (or any available option) 7. Click OK twice. -- Hope this is helpful Appreciate that you provide your feedback by clicking the Yes button below if this post have helped you. Thank You cheers, francis "barkat" wrote: How can I change the colour of a dated box of excel after the date is over. I want the programme to read date automatically from pc and change colour. |
#3
|
|||
|
|||
colour change of dated box
Hi,
"After the date is over" To conditionally format your cell(s): In 2003: 1. Select the cells you want to format 2. Choose Format, Conditional Formatting 3. Choose Formula is from the first drop down 4. In the second box enter the formula: =A1TODAY() 5. Click the Format button 6. Choose a color on the Patterns tab (or any available option) 7. Click OK twice. In 2007: 1. Highlight all the cells on the rows you want formatted 2. Choose Home, Conditional Formatting, New Rule 3. Choose Use a formula to determine which cell to format 4. In the Format values where this formula is true enter the following formula: =A1TODAY() 5. Click the Format button and choose a format. 6. Click OK twice -- If this helps, please click the Yes button Cheers, Shane Devenshire "barkat" wrote: How can I change the colour of a dated box of excel after the date is over. I want the programme to read date automatically from pc and change colour. |
Thread Tools | |
Display Modes | |
|
|