Column shading color based on specific cell content

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

Guest

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding columns with shaded headers 4
Coding needed for shaded cells 7
have a range of cells shade a certain color 2
Comparison of columns using Conditional Formatting 3
macro to disallow shading in certain columns 2
Seclect Column or Range according to Cell's Contents 3
Searching for a string and then shading the row 2
Shade Cells Yellows if Column (D) has a value of C in Cell 1

Top