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

--
Jacob (MVP - Excel)


"vinu" wrote:

Hi,

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...

Thanks in anticipation


.