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.