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
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.
ReplyDeleteHi jaredpdrake:
ReplyDeleteWhat 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
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.
ReplyDeleteFor 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.