**Question description:**

*This user has given permission to use the problem statement for this blog.*

I'm trying to turn certain numeric cell numbers into colors:
Example. If C1 and C2 are both between 1 and 15 I want them to be yellow. If they C1 is 4 which would be yellow but C2 is 22 I want them to be both blue. How can I do this?

Solved by X. D. in 59 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
22/06/2018 - 03:09

hi

User
22/06/2018 - 03:09

hello

Excelchat Expert
22/06/2018 - 03:10

I will now restate the problem

Excelchat Expert
22/06/2018 - 03:10

tell me if I correctly understood your question

User
22/06/2018 - 03:10

ok

Excelchat Expert
22/06/2018 - 03:11

if C1 and C2 are between 1 and 15 you have to make the cell to become yellow

User
22/06/2018 - 03:11

yes

User
22/06/2018 - 03:11

both cells would be yellow

User
22/06/2018 - 03:11

if either C1 and C2 are over 15 they would both be blue

User
22/06/2018 - 03:12

and if either is about 30 both would be red

Excelchat Expert
22/06/2018 - 03:12

but if c1 satisfy the condition and c2 doesn't satisfy you want both cells to be blue

User
22/06/2018 - 03:13

yes. essentially I'm trying to color code based on the highest value of either cell

User
22/06/2018 - 03:13

the conditions would be 1-15 16-30 and 31 to 100

Excelchat Expert
22/06/2018 - 03:13

ok so depending on the highest value of cells you want tto colour code

User
22/06/2018 - 03:14

yes

Excelchat Expert
22/06/2018 - 03:14

if the value between less than 15 you want yellow

Excelchat Expert
22/06/2018 - 03:14

if 15-30 blue

Excelchat Expert
22/06/2018 - 03:14

if 30-100 red is it so

Excelchat Expert
22/06/2018 - 03:14

?

User
22/06/2018 - 03:14

yes

Excelchat Expert
22/06/2018 - 03:15

Thanks for confirmation

Excelchat Expert
22/06/2018 - 03:15

please wait while I find a formula for you :-)

User
22/06/2018 - 03:22

?

Excelchat Expert
22/06/2018 - 03:22

yeah i am preparing

Excelchat Expert
22/06/2018 - 03:23

The concept we are going to apply is

Excelchat Expert
22/06/2018 - 03:23

first we find the largest number of the two entries (c1 and c2)

Excelchat Expert
22/06/2018 - 03:24

then we get the largest number of c1 and c2 in c3 from the formula (=LARGE(C1:C2,1))

Excelchat Expert
22/06/2018 - 03:25

Now based on the values of c3 we can conditional format the cells c1 and c2

User
22/06/2018 - 03:26

ok

Excelchat Expert
22/06/2018 - 03:26

Now iam working on conditional formating

Excelchat Expert
22/06/2018 - 03:27

please wait some more time :-)

Excelchat Expert
22/06/2018 - 03:29

ok Thanks for your patience

Excelchat Expert
22/06/2018 - 03:29

Now we can conditional format

Excelchat Expert
22/06/2018 - 03:30

select the row you want conditional format

Excelchat Expert
22/06/2018 - 03:30

.

[Uploaded an Excel file]

Excelchat Expert
22/06/2018 - 03:31

click on conditional formatting

[Uploaded an Excel file]

Excelchat Expert
22/06/2018 - 03:32

Now click on format cells if "custom formula is"

[Uploaded an Excel file]

Excelchat Expert
22/06/2018 - 03:37

as custom formula enter formula as "=15>$C$3>1"

[Uploaded an Excel file]

Excelchat Expert
22/06/2018 - 03:38

click on that paint bucket make the color as yellow

[Uploaded an Excel file]

Excelchat Expert
22/06/2018 - 03:39

Now click on add another rule

Excelchat Expert
22/06/2018 - 03:39

.

[Uploaded an Excel file]

Excelchat Expert
22/06/2018 - 03:41

make the formula as "=30>$C$3>15" and fill color as blue

[Uploaded an Excel file]

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