# Excel - IF Function Problem - Expert Solution

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
User 19/10/2017 - 10:52
yer
Excelchat Expert 19/10/2017 - 10:52
Ok
Excelchat Expert 19/10/2017 - 10:52
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
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
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
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
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
Excelchat Expert 19/10/2017 - 10:58
Attached
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
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
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

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.