Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
[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(),F1<TODAY())" 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(),F1<TODAY()+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
Posted to microsoft.public.excel.misc
|
|||
|
|||
[Flashing] RED before renewal date
A slight addition in the above formula
=AND(F1<"",OR(F1<=TODAY(),F1<TODAY())) 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(),F1<TODAY())" 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(),F1<TODAY()+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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flashing RED before renewal date | Excel Discussion (Misc queries) | |||
Hi Blinking/Flashing Text in cell based upon date value | Excel Discussion (Misc queries) | |||
how to get auto next due date for the renewal of some document | Excel Discussion (Misc queries) | |||
Calcualtion of renewal | Excel Worksheet Functions | |||
Calcualtion of renewal | Excel Worksheet Functions |