Question description:
This user has given permission to use the problem statement for this
blog.
Hi guys ,
I want to update an if condition so that if the value is less then 18 then it should say Great if more then 24 it should say too old and if anything else then it should say "wait
Thanks
Solved by D. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
06/08/2017 - 08:36
Hi there!
User
06/08/2017 - 08:36
Hi
User
06/08/2017 - 08:37
this is great , never used this website before was just testing my luck and very excited to find such an amazing help
Excelchat Expert
06/08/2017 - 08:37
Great, glad to help you! :)
User
06/08/2017 - 08:37
like I might want to add an effect and color like conditional formating
User
06/08/2017 - 08:38
result is less then it should have red color and blinking and if greater then it should have green color and blinking
Excelchat Expert
06/08/2017 - 08:39
Sure! Due to our policy of 1 question per 20 minute session, I may have to ask you to re-post your question and use the description EXPERTJS
Excelchat Expert
06/08/2017 - 08:39
But for this IF statement condition, do you have a sample document or do you prefer we just demonstrate it from this spreadsheet?
User
06/08/2017 - 08:40
it's the same thing jus tsome conditional formating but if I have to then I'll do that ..
User
06/08/2017 - 08:42
like the c2 has value 24 , so the result of b2 should be like if c2 is > then 26 it should say Great and blinking green , and if its less then 18 it should say bad and blinking red and between it should say "do nothing" with black background
User
06/08/2017 - 08:43
is this clear ?
User
06/08/2017 - 08:44
are you there ?
Excelchat Expert
06/08/2017 - 08:44
Right. But blinking conditional formatting would require VBA coding.
Excelchat Expert
06/08/2017 - 08:45
Yes. I was working on the formula, could you please check if that is the output you desire
User
06/08/2017 - 08:45
hmm ok then just green background for greator then and red background for less then
User
06/08/2017 - 08:45
ok sure , very excited
User
06/08/2017 - 08:46
I need to apply that in an excel worksheet so I hope your solution will work over there
User
06/08/2017 - 08:46
old version ms excel 2003
Excelchat Expert
06/08/2017 - 08:46
Yes, it would be more complicated in VBA and cost more. It's north worth it if you ask me. But if that is the output you would like, then that would be fine.
Excelchat Expert
06/08/2017 - 08:46
Oh. Yes this is just a nested IF statement.
User
06/08/2017 - 08:46
ok cool
Excelchat Expert
06/08/2017 - 08:47
So what it does is it creates multiple conditions and if that condition is not met, it will proceed to the next condition in sequence.
User
06/08/2017 - 08:47
yes
Excelchat Expert
06/08/2017 - 08:47
If you see in the formula, you may just simply change the parameters or add another IF statement inside it.
Excelchat Expert
06/08/2017 - 08:48
Good to hear the formula works for you. If you still would like to proceed with the simple conditional formatting, please re-post your question and use the description EXPERTJS
User
06/08/2017 - 08:49
I don't see the formaloa
User
06/08/2017 - 08:49
where is it
Excelchat Expert
06/08/2017 - 08:50
One moment.
User
06/08/2017 - 08:50
actually I want the value to be in one cell
User
06/08/2017 - 08:50
like the output of b2 say is what we are calculating ...
User
06/08/2017 - 08:50
based on the value in c2
User
06/08/2017 - 08:51
c2 > 24 = To OLD Green Background
Excelchat Expert
06/08/2017 - 08:51
Yes, that is what it does on D2.
Excelchat Expert
06/08/2017 - 08:52
[Uploaded an Excel file]
Excelchat Expert
06/08/2017 - 08:52
Kindly check the attached.
User
06/08/2017 - 08:52
yes , but I want the formula to work in one cell
User
06/08/2017 - 08:53
ahh great I see it working
Excelchat Expert
06/08/2017 - 08:53
Does it work for you?
User
06/08/2017 - 08:53
ds
User
06/08/2017 - 08:54
can we have different backgrounds
Excelchat Expert
06/08/2017 - 08:54
I attached the file with the formula.
Excelchat Expert
06/08/2017 - 08:54
Yes we can, it's just a sample file so you'll get the how the formula works. :)
Excelchat Expert
06/08/2017 - 08:55
Session is about to end in a minute. You may end the session now if you want, and post the question about conditional formatting afterwards. :)
Excelchat Expert
06/08/2017 - 08:55
Glad to have helped you.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
