Hi all, I'm trying to write a macro that shades a specific range of
columns depending on the contents of another cell. For example, I want
to shade in green all columns whose date (that's the column heading) is
less or equal to a specific date to be inputed in another cell. How can
I do that??

Conditional formatting will do that for you!
Select columns in your specific range (say A:G, let the cell containing the
date input H1)!
Formats/Conditional formatting/formula: =A$1<=$H$1
Choose green background!

Regards,
Stefi

„bliten_bsasâ€� ezt Ã*rta:

> Hi all, I'm trying to write a macro that shades a specific range of
> columns depending on the contents of another cell. For example, I want
> to shade in green all columns whose date (that's the column heading) is
> less or equal to a specific date to be inputed in another cell. How can
> I do that??
>
>