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