formula on conditional formatting

[Shamz41]

Hi

Can I know what is the formula I should input on a date column (Column F) to apply in coditional formating for dates coming up for expiry within 3 days from the current date. I have a "Now" function in cell G7.

[NickyC]

Hi
assuming the cell with the date value is A1, try this

Please Login or Register  to view this content.

[Shareez Saleem]

Select the range of cell and do a conditional formatting > New Rule > Use a Formula to determine which cell to format > Enter the formula $F2=TODAY()+3

[Shamz41]

thanks it worked.