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