Thursday, February 7, 2013

yogi_Work Around For Multi-Conditional Formatting Dates In A Column Based on A Formula


                                          Google Spreadsheet   Post  #1021
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 07, 2013


this post is 

in response to a comment by jaredpdrake on Feb-07-2013 in my following blog post:

yogi_Work Around For Conditionally Formatting Dates In A Column Based on A Formula-1, 
http://yogi--anand-consulting.blogspot.com/2012/04/yogiwork-around-for-conditionally_24.html


3 comments:

  1. Thanks. Would you be able to explain what each part of the formula does so I could possibly use this type of feature again in a different manner? I'm not really sure where one section ends and the next begins, or what all the numbers are.

    ReplyDelete
  2. Hi jaredpdrake:

    What the formula in cell D2 does is assign a number to each cell one of the values 1,2,3,4 that meet the criteria for coloring a cell as Black, Red, Yellow, Green; and the rest of the cells are kept with the White background.

    I hope this helps.

    Make It A Great One.
    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete
  3. That doesn't help a whole lot, sorry. I wanted to know where each criteria statement started and ended in the formula, and how to read what each one does. There are a lot of commas and parentheses in the formula, so it's a little confusing to determine the use of each.

    For example, I'm pretty sure (if(C2:C="","" is one criteria statement, but I could be wrong. If this is the start and end of one statement, what does the C2:C="","" mean? I'd like to understand more about this formula so I can build spreadsheets using this feature but use different amounts of criteria and different columns.

    ReplyDelete