
Active Member

March 1, 2019

Hi there. Hoping you can help me find a quick solution to my problem. Please see my attachment.
What I am needing is an easily visible way to be alerted when column "S" is less than 15. If that happens, I need it to say "under". Also, can I make it put "under" in red font?
2) The other thing I would like for it to do is to calculate the total amount of cells in column "S" that are 15 and over. How can I do that?
Thanks!

VIP

Trusted Members

June 25, 2016


Active Member

March 1, 2019

Hi Sunny, thanks for trying to help me with this. I'm working on Q2) and it's almost the formula I need.
I don't think I explained it exactly right. I don't need it to calculate the "sum" of the cells in column "S" that are ">=15". I need to tell me, out of the 26 cells that are in that column, how many of them (the total number) are ">=15". Can you help me with that, I hope? :o)

VIP

Trusted Members

June 25, 2016


Active Member

March 1, 2019

I was able to get the formula to work for question 2 thanks to your help!
Going back to question 1. It's almost there, but the problem is that it will only give me the alert "under" in column T in cell 2 and only if I specify a certain cell on its own. I'm inserting the formula in column T cell 2. Am I doing that part correctly?
What I need it to do is say "under" in column T for each individual cell number that is under the number 15 in column S. (I hope that makes sense.)
1 Guest(s)
