Column shading color based on specific cell content
 

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??

Column shading color based on specific cell content
 

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??