using conditional formatting

[Green1972]

Hello.
Ok what i have is a range of cells containing different dates (row E100 to BB100). In cell B20 i have another date. What i want to do is use conditional formatting to highlight the cells in row E100 to BB100 that are within 7 days of the date in cell B20. Is it even possibel.

 

[mouse88]

I think you need to create your own rule for conditional formatting using a formula. Haven't used this before but think it is what u need.

 

[srizki]

Search ="DATEDIF in conditional format", you will find the answer.

 

[T. Valko]

Hello.
Ok what i have is a range of cells containing different dates (row E100 to BB100). In cell B20 i have another date. What i want to do is use conditional formatting to highlight the cells in row E100 to BB100 that are within 7 days of the date in cell B20. Is it even possibel.

What version of Excel are you using?

 

[srizki]

Try this,
Highlight your range E100:BB100, and use this formula in conditional format,

=AND(DATEDIF($E$100,A10,"D")<7)


Where A10 is where your date is, and format it as you want.

 

[srizki]

Sorry, do not use $ signs

 

[Green1972]

Hello all. I'am using Excel 2010

 

[Green1972]

Hi have tried the formula "Sirzki" posted and i dont know how to do a search in conditional formatting.

 

[T. Valko]

Hello.
Ok what i have is a range of cells containing different dates (row E100 to BB100). In cell B20 i have another date. What i want to do is use conditional formatting to highlight the cells in row E100 to BB100 that are within 7 days of the date in cell B20. Is it even possibel.

Hello all. I'am using Excel 2010

I don't have Excel 2010 but this should be the same as it is in Excel 2007.

Select the *entire* range E100:BB100 starting from cell E100.
Cell E100 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

• Goto the Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a formula to determine which cells to format
• Enter this formula in the box below:
  =AND(E100>=$B$20-7,E100<=$B$20)
• Click the Format button
• Select the desired style(s)
• OK out

 

[Green1972]

Hi. I tried your formula (T Valko) but it didn;t work any other ideas.