# Excel - How to Change Background Color Based on Cell Value - Expert Solution

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

I have a formula of color changing (conditional formatting), you just need to fix it.
Solved by Z. W. in 26 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 01/01/2018 - 06:52
Hello Sir
User 01/01/2018 - 06:52
Happy New Year!!!
Excelchat Expert 01/01/2018 - 06:52
Excelchat Expert 01/01/2018 - 06:52
Happy New Year :)
User 01/01/2018 - 06:52
Please look at to O column
Excelchat Expert 01/01/2018 - 06:54
I am watching the column O.
User 01/01/2018 - 06:54
I have three formulas
User 01/01/2018 - 06:54
and three criterias
User 01/01/2018 - 06:55
products until 30 euro selling price should be no less than 50% profit products from 31 euro selling price to 50 euro selling price should be no less than 40% profit products above 51 selling price should not be less than 30% profit
Excelchat Expert 01/01/2018 - 06:55
=AND(\$O2<>"",\$O2>50,\$T2<30)
Excelchat Expert 01/01/2018 - 06:55
Why it is linked to T column?
User 01/01/2018 - 06:56
my mistake
Excelchat Expert 01/01/2018 - 06:57
Can you please explain the changes required.
Excelchat Expert 01/01/2018 - 06:58
There are multiple requests in the same question.
Excelchat Expert 01/01/2018 - 06:58
As per the policies, we can serve one question at a time.
User 01/01/2018 - 06:58
yes
Excelchat Expert 01/01/2018 - 07:00
=AND(\$O2<>"",\$O2>=31,\$O2<=40,\$T2<40)
Excelchat Expert 01/01/2018 - 07:01
Looks like second condition need to be changed from \$O2<=40 to \$O2<=50
User 01/01/2018 - 07:01
User 01/01/2018 - 07:01
User 01/01/2018 - 07:01
Please fix them as per criteria's
Excelchat Expert 01/01/2018 - 07:01
What colours are required for each criterion?
Excelchat Expert 01/01/2018 - 07:02
What are O and T columns?
User 01/01/2018 - 07:02
same color, red
User 01/01/2018 - 07:02
actually O column means price
User 01/01/2018 - 07:02
and T column means profit %
Excelchat Expert 01/01/2018 - 07:02
Ok
User 01/01/2018 - 07:03
Sir, do you understand everything?
User 01/01/2018 - 07:03
Excelchat Expert 01/01/2018 - 07:03
I am reviewing the requirements. Please give me few minutes.
User 01/01/2018 - 07:03
Excelchat Expert 01/01/2018 - 07:08
Ok. I have corrected it. Please check.
User 01/01/2018 - 07:08
ok
Excelchat Expert 01/01/2018 - 07:09
Please visit Got It Pro for new queries. Have a great day ahead:)
User 01/01/2018 - 07:09
User 01/01/2018 - 07:09
I am checking the formula
Excelchat Expert 01/01/2018 - 07:10
I have applied the formulas as per the given details. It is highlighting the corresponding rows.
User 01/01/2018 - 07:10
I think it is not working
Excelchat Expert 01/01/2018 - 07:11
The range is given till row 18
User 01/01/2018 - 07:11
Please apply it to full T row
User 01/01/2018 - 07:11
and O
Excelchat Expert 01/01/2018 - 07:11
If you would like to extend to all rows, please change 18 to 1000 (example) in the conditional formatting)
User 01/01/2018 - 07:11
ok
User 01/01/2018 - 07:13
sir I think it is not working
Excelchat Expert 01/01/2018 - 07:13
Please keep the range from row 2 to 1000
Excelchat Expert 01/01/2018 - 07:13
You are trying to change the range that was corrected earlier.
Excelchat Expert 01/01/2018 - 07:13
User 01/01/2018 - 07:14
yes
Excelchat Expert 01/01/2018 - 07:14
and T2:T10000
User 01/01/2018 - 07:14
just one more try
User 01/01/2018 - 07:15
Excelchat Expert 01/01/2018 - 07:16
It is taking time, May be a problem with the sheet.
User 01/01/2018 - 07:16
oh ok
Excelchat Expert 01/01/2018 - 07:16
I am keep on getting error to reload the sheet.
Excelchat Expert 01/01/2018 - 07:16
Hope, it is working fine now.
User 01/01/2018 - 07:17
yes
User 01/01/2018 - 07:17
just sec
Excelchat Expert 01/01/2018 - 07:17
Great.
Excelchat Expert 01/01/2018 - 07:17
Thank you.
User 01/01/2018 - 07:17
I will copy the formula
Excelchat Expert 01/01/2018 - 07:17
Excelchat Expert 01/01/2018 - 07:17
User 01/01/2018 - 07:17
ok
User 01/01/2018 - 07:18
thank you sir

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.