Date Conditional formatting in a cell

[angandbri]

Hi - I need to format a sheet that has a date in one column - say B3. I am attempting to color a cell 61 days from now (same row, just farther down-one cell only, not the whole row) Cannot find the right formatting & formula. I also need this for 91 & 181 days. Can anyone help?

 

[venkat1926]

select a cell

in conditional formatting window

first min window
cell value is
second mini window
greater than or equal to
third mini window
=today()+63 (that equal to sign is necessary)

you can copy the cell down with pastespecial - format

 

[pedro-egoli]

Format each cell as Date.
Formulas in each as per below.
For each cell use conditional formatting using the condition as
Formula is =(b3>1)
Select whatever pattern you require

I have grouped the cells together just for display. Put the formula in whatever cell you like and do conditional formatting just for each such cell

Excel Workbook
	A	B	C	D	E	F
1	*	*	*	*	*	*
2	*	*	*	61 days	91days	181 days
3	*	18-08-11	*	20-10-11	17-11-11	15-02-12
Sheet1

Pedro