• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting Help

B

brianmock

Member
I need to be able to conditionally format an excel sheet such that dates less than x are highlighted one color and those dates less then y are another highlight and those less than z are a third color with those dates greater than z are a fourth color.

I have attached a brief sample to domonstrate the layout.

There are multiple columns and multiple dates which may change daily
 

Attachments

  • Cond Formatting Example.xlsx
    9.5 KB · Views: 4
upload_2014-2-10_13-3-25.png

How to setup the CF rules: Note the use of dollar signs. DEfault color of all the cells if red (other)
 
Is there a way to "Copy & paste" this conditional formatting if there are 1,000 columns... each with different dates in rows 2,3,4
 
You could (copy, paste special - formatting), but the preferred method would be to just extend the "Applies to range" to incude the columns you want. I wrote the formulas so that it can be applied to any size range.
 
You must log in or register to reply here.
Back
Top