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
|
|||
|
|||
[Flashing] RED before renewal date
Hi,
Mistakenly I removed the previous post... That I pasted some parts below. Actually Jacob helped me on highlighting the renewal date with 10 days window with a conditional formula and I incorporated that to highlight the crossed out dates by conditioning the cell with "=OR(F1=TODAY(),F1TODAY())" with Patterning YELLOW. As I formatted the entire column the cells that was blank also turn Yellow. Any help.... Regards, Vinu I have some vehicle data that we update time to time. The below is an eg from the data Coolum no Heading Data C Vehicle License Plate Number TN 07 S 0003 D Vehicle Type Sumo E Vehicle Year 2008 F Insurance renewal date 31-03-2010 In that we have a renewal date in one column I wanna assign some automated indication(i.e.with some formulas in condition formatting) to alert us priory on renewal date... Jacob-----------1. Select the cell/Range (column F). Please note that the cell reference F1 mentioned in the formula is the active cell in the selection. Active cell will have a white background even after selection 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =AND(F1=TODAY(),F1TODAY()+10) 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK PS: If you are using XL2007 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format. Enter the formula in the box below. Adjust the 10 to suit...The current formula will highlight dates which are due in 10 days |
#2
|
|||
|
|||
[Flashing] RED before renewal date
A slight addition in the above formula
=AND(F1"",OR(F1=TODAY(),F1TODAY())) Place the cursor in A1 cell and apply the conditional formatting formula, Active cell should be F1. (Active cell will have a white Background after selection also) -- Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "vinu" wrote: Hi, Mistakenly I removed the previous post... That I pasted some parts below. Actually Jacob helped me on highlighting the renewal date with 10 days window with a conditional formula and I incorporated that to highlight the crossed out dates by conditioning the cell with "=OR(F1=TODAY(),F1TODAY())" with Patterning YELLOW. As I formatted the entire column the cells that was blank also turn Yellow. Any help.... Regards, Vinu I have some vehicle data that we update time to time. The below is an eg from the data Coolum no Heading Data C Vehicle License Plate Number TN 07 S 0003 D Vehicle Type Sumo E Vehicle Year 2008 F Insurance renewal date 31-03-2010 In that we have a renewal date in one column I wanna assign some automated indication(i.e.with some formulas in condition formatting) to alert us priory on renewal date... Jacob-----------1. Select the cell/Range (column F). Please note that the cell reference F1 mentioned in the formula is the active cell in the selection. Active cell will have a white background even after selection 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =AND(F1=TODAY(),F1TODAY()+10) 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK PS: If you are using XL2007 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format. Enter the formula in the box below. Adjust the 10 to suit...The current formula will highlight dates which are due in 10 days . |
Thread Tools | |
Display Modes | |
|
|