Currently I am using this formula inside of a cell:
Code: Select all
=IF(SUM(J5:J65)=1;STYLE("yellowhl");STYLE("default")) &""& IF(SUM(J5:J65)=1;"Behind";"")
So while I have the sheet doing what I want it to do essentially, its putting this very annoy 0 that appears to be a text zero right next to the "Behind", apparently because STYLE() always returns a 0.
Ive tried having the global setting calc - view - zero values set to off (does not work in this instance but applies to the rest of the sheet), Ive tried eliminating leading zeroes (does not work in this instance), and Ive tried embedding the above formula in another IF() statement and telling it that if "0Behind" is true, post "Behind" instead (returns a #VALUE error), and have now run out of ideas about how to get this superfluous 0 out of the cell.
Any advice would be helpful on how to either prevent STYLE() from returning a 0, or how else I can accomplish my goal of BOTH highlighting the cell yellow, and also posting the short text "Behind" with it without extraneous text included. I feel that there must be a simple solution to this, but do not have the expertise in spreadsheets to know what it is, and its proving to be very hard trying to obtain the answer through websearching (discovered some interesting things about AOO by trying, but have not yet found my solution).
Thank you in advance!