# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have a question about Excel, and was wondering if you had a solution. When I am analyzing scores from patients, I typically have to state how many clients had an improved score. So far, I have done this manually by looking at each score from each client. This gets tedious as I have 15-200 or more clients to look at. Is there a formula or program that can compare scores to see if there is an increase or decrease between multiple scores? Thank You,
Solved by I. Y. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 07/06/2018 - 09:10
Hello there, welcome to Got It Pro.
User 07/06/2018 - 09:10
150 Employees
Excelchat Expert 07/06/2018 - 09:11
Hope you are doing well.
User 07/06/2018 - 09:11
Yes
User 07/06/2018 - 09:11
Did you see the users question, I am in the IT dept
Excelchat Expert 07/06/2018 - 09:11
Yes.
User 07/06/2018 - 09:12
Do you know what formula to use ??
Excelchat Expert 07/06/2018 - 09:12
Okay let me show you a few ways.
Excelchat Expert 07/06/2018 - 09:13
Please have a look at the Excel Online Panel on the middle of the screen.
User 07/06/2018 - 09:13
I am seeing it,,
Excelchat Expert 07/06/2018 - 09:14
Alright.
Excelchat Expert 07/06/2018 - 09:14
So, does the dataset look okay?
User 07/06/2018 - 09:15
Yes,,,
Excelchat Expert 07/06/2018 - 09:15
Alright.
Excelchat Expert 07/06/2018 - 09:16
Does this work?
User 07/06/2018 - 09:17
I think so....I am not the one asking. Its a data analyst. Did you use a formulac??
Excelchat Expert 07/06/2018 - 09:18
Alright. No I didn't use a formula. I used conditional formatting.
User 07/06/2018 - 09:18
He send an email with the question I presented to you guys
Excelchat Expert 07/06/2018 - 09:18
I can add a formula to the condition as well.
Excelchat Expert 07/06/2018 - 09:18
Okay, so this would do fine.
User 07/06/2018 - 09:18
Excelchat Expert 07/06/2018 - 09:18
Analysts always prefer visual stuff.
Excelchat Expert 07/06/2018 - 09:18
Alright.
Excelchat Expert 07/06/2018 - 09:20
Okay I have added the formula.
Excelchat Expert 07/06/2018 - 09:20
Let me explain how I did it.
Excelchat Expert 07/06/2018 - 09:21
May I know at first which version of Excel are you using?
User 07/06/2018 - 09:21
2007
Excelchat Expert 07/06/2018 - 09:21
Alright
User 07/06/2018 - 09:21
I dont see the formula on there,,
Excelchat Expert 07/06/2018 - 09:22
Okay, so at first you select the cells D3:D12
Excelchat Expert 07/06/2018 - 09:22
Go to Home> Conditional Formatting
Excelchat Expert 07/06/2018 - 09:22
Manage rules
Excelchat Expert 07/06/2018 - 09:23
First you'll have to copy this data to Excel on your computer.
Excelchat Expert 07/06/2018 - 09:23
Now select the cells D3:D12
Excelchat Expert 07/06/2018 - 09:23
Home > Conditional Formatting>New Rule
Excelchat Expert 07/06/2018 - 09:24
Select Use a formula to determine which cells to format
Excelchat Expert 07/06/2018 - 09:24
On the input bar add =D3:D12>56
User 07/06/2018 - 09:25
Alright,,,,hold on. I am creating it in Excel
Excelchat Expert 07/06/2018 - 09:25
Click format
Excelchat Expert 07/06/2018 - 09:25
Okay.
Excelchat Expert 07/06/2018 - 09:27
Were you able to do it?
User 07/06/2018 - 09:28
Yes,,,thx for you help
Excelchat Expert 07/06/2018 - 09:28
Excellent
Excelchat Expert 07/06/2018 - 09:28
You're welcome
Excelchat Expert 07/06/2018 - 09:28
Thanks for using Got It Pro.
Excelchat Expert 07/06/2018 - 09:28
Have a good day!!

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.