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.