Yes, that is exactly what I wanted.

Al

"flummi" wrote:

If this is still open:

Your date in B1:

select format--conditional format
select "formula is"
type =B1<today()+30
click "format"
select the formatting you want
click ok
click ok
copy B1 and "paste special--format" into all cells that need
formatting.


Is that what you wanted?

Hans