Question description:
This user has given permission to use the problem statement for this
blog.
Turning a cell a colour if another cell is =2 or lower
can show in example on sheet
Solved by I. J. in 16 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
19/10/2017 - 10:50
hi how are you
Excelchat Expert
19/10/2017 - 10:50
Hi, It's pleasure to assist you today:)
Excelchat Expert
19/10/2017 - 10:50
I am fine, Thankyou. Hope you are doing well
Excelchat Expert
19/10/2017 - 10:50
Please enter the sample in the preview
User
19/10/2017 - 10:51
can u s
User
19/10/2017 - 10:51
see that
Excelchat Expert
19/10/2017 - 10:51
or the requirement can be achieved using conditional formatting
Excelchat Expert
19/10/2017 - 10:51
Sure.
Excelchat Expert
19/10/2017 - 10:51
I can see it
Excelchat Expert
19/10/2017 - 10:51
it is based on column D, i guess
User
19/10/2017 - 10:51
yes if it is = or less then column E
Excelchat Expert
19/10/2017 - 10:52
Sure. It can't be done in excel online.
Excelchat Expert
19/10/2017 - 10:52
I can guide you the steps
Excelchat Expert
19/10/2017 - 10:52
Can you please follow them
User
19/10/2017 - 10:52
yer
Excelchat Expert
19/10/2017 - 10:52
Ok
Excelchat Expert
19/10/2017 - 10:52
Please select column F
Excelchat Expert
19/10/2017 - 10:52
and goto Home menu and select conditional formatting
Excelchat Expert
19/10/2017 - 10:52
Not in the preview
Excelchat Expert
19/10/2017 - 10:52
Please try in local file
User
19/10/2017 - 10:53
yer sorry wrong tab up
Excelchat Expert
19/10/2017 - 10:53
Sure
Excelchat Expert
19/10/2017 - 10:53
Please open the local file
Excelchat Expert
19/10/2017 - 10:53
and select column F
User
19/10/2017 - 10:53
yep
Excelchat Expert
19/10/2017 - 10:53
When you click on conditional formatting, use custom formula option
Excelchat Expert
19/10/2017 - 10:53
and enter the following formujla
Excelchat Expert
19/10/2017 - 10:54
=and($F1>0,$F1<=2)
Excelchat Expert
19/10/2017 - 10:54
and select the colour of your choice
Excelchat Expert
19/10/2017 - 10:54
and click on
User
19/10/2017 - 10:54
sorry i dont have a custom formula tab
Excelchat Expert
19/10/2017 - 10:54
Click ok
Excelchat Expert
19/10/2017 - 10:54
It is not in the tabl
Excelchat Expert
19/10/2017 - 10:54
when you click on conditional formatting, a popup appears
User
19/10/2017 - 10:55
i have a drop down box come up no pop up
Excelchat Expert
19/10/2017 - 10:56
I am working on the local file and sending you the file
Excelchat Expert
19/10/2017 - 10:56
You can download it
User
19/10/2017 - 10:56
ok
User
19/10/2017 - 10:57
is it part of the rules manager
Excelchat Expert
19/10/2017 - 10:57
https://www.dropbox.com/s/nxsm86tiiglgyfi/Blank.xlsx?dl=0
Excelchat Expert
19/10/2017 - 10:57
Please download the file from this link
Excelchat Expert
19/10/2017 - 10:57
It is from manage rules
Excelchat Expert
19/10/2017 - 10:57
and click on new rules
Excelchat Expert
19/10/2017 - 10:57
then a popup opens. You need to select the last optoion
Excelchat Expert
19/10/2017 - 10:58
However, i have sent the file
Excelchat Expert
19/10/2017 - 10:58
Please download from it
Excelchat Expert
19/10/2017 - 10:58
Attached
[Uploaded an Excel file]
User
19/10/2017 - 10:59
can u go through it again
User
19/10/2017 - 10:59
so its the last one on the list
Excelchat Expert
19/10/2017 - 10:59
Hope, you have opened the file
User
19/10/2017 - 10:59
use a formula to determine witch cell to format ??
Excelchat Expert
19/10/2017 - 11:00
yes that is right
Excelchat Expert
19/10/2017 - 11:00
=and($D1>0,$D1<=2)
Excelchat Expert
19/10/2017 - 11:00
copy this formula in that
Excelchat Expert
19/10/2017 - 11:00
and select the format option
Excelchat Expert
19/10/2017 - 11:00
and click on Fill
Excelchat Expert
19/10/2017 - 11:00
and select red colour
Excelchat Expert
19/10/2017 - 11:00
It shows the red colour
User
19/10/2017 - 11:01
can i change it if its not all 2
Excelchat Expert
19/10/2017 - 11:02
Yes. You can check it
Excelchat Expert
19/10/2017 - 11:02
I am giving condition that the number in column D is greater than zero and less than 2
User
19/10/2017 - 11:02
for example if i wanted some other down further to turn red if 5 or less ??
Excelchat Expert
19/10/2017 - 11:03
Based on that, i have given formula
Excelchat Expert
19/10/2017 - 11:03
Hope, you have downloaded the file and checke the result as well.
User
19/10/2017 - 11:04
can you change some rows to be like 5 or less turn red ??
User
19/10/2017 - 11:04
ok so further down you cant change it to 5
Excelchat Expert
19/10/2017 - 11:05
change 2 to 5 in the formula
Excelchat Expert
19/10/2017 - 11:05
when you click on manage rules, you will get a popup with the rules present
User
19/10/2017 - 11:05
yer that will work
Excelchat Expert
19/10/2017 - 11:05
and now, you can click on Edit and change the formula and replace 2 to 5
Excelchat Expert
19/10/2017 - 11:05
Ok.
Excelchat Expert
19/10/2017 - 11:05
Great
User
19/10/2017 - 11:06
thank you for your time
Excelchat Expert
19/10/2017 - 11:06
Hope, i have provided the solution.
Excelchat Expert
19/10/2017 - 11:06
You are welcome
Excelchat Expert
19/10/2017 - 11:06
Please visit Got it Pro
Excelchat Expert
19/10/2017 - 11:06
Please end the session and leave 5-stars
User
19/10/2017 - 11:06
have a great day
Excelchat Expert
19/10/2017 - 11:06
Have a great day ahead:)
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.
