Column shading color based on specific cell content

  • Thread starter Thread starter bliten_bsas
  • Start date Start date
B

bliten_bsas

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:
 
Back
Top