**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

HI, It's pleasure to help you today:)

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

IDK about formula

User
01/01/2018 - 07:01

Please fix it

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

Sorry for my bad english

Excelchat Expert
01/01/2018 - 07:03

I am reviewing the requirements. Please give me few minutes.

User
01/01/2018 - 07:03

take your time sir :)

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

Sir Please wait

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

Please check with O2: O10000

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

Sir Please check column 23

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

You can download the file.

Excelchat Expert
01/01/2018 - 07:17

From File / download as Excel.

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.*