Excel - IF Function Problem - Expert Solution

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.

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc