Originally Posted by
danison
What I was hoping is that to the right of columns J - Q, I could return a text value based on the CF in the first 8 columns. The formula I wanted to build would check to see if 3 of the cells were green in columns A3: H3, and one or two also were yellow, in which case it would return the word "Five". If there were four cells green (and one or two may be yellow, however is not dependent on having yellow cells to return the value), the formula would return the word "Four". If there are 5 green cells (and again may have one or two yellow however not formula dependent), the value returned would be "Three". Next if there were 5 Green AND one or two must be Yellow, value returned would be "Two". Finally if there were 6 green cells in A3:H3 (and one or two may be yellow however not dependent), the value returned would be "One".
Bookmarks