Conditional Formatting - If within a range, generates a word?

Chris Norton

New Member
Joined
Sep 16, 2002
Messages
11
Hi folks

Sorry to trouble you all - I would be grateful for a little help in that I want to create a query that allows me to highlight the following;

If Cell C6 is between 0 & 5, it displays the word "LOW" and the cell is coloured green background
If it is between 6 & 10, it displays the word "MEDIUM" and the cell is coloured amber background
If it is between 11 & 15 it displays the word "HIGH" and the cell is coloured red background

Would appreciate anyone's guidance or advice on this. Many thanks in advance.
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Marcílio_Lobão

Well-known Member
Joined
Oct 7, 2013
Messages
777
Office Version
  1. 2007
Platform
  1. Windows
Chris, Good afternoon.

You can't use conditional formating to give back answers than a cosmetic effect.

1) Use some function to give you the text answers. (IF, VLOOKUP, CHOOSE+MATCH etc)

2) Create rules at conditional formating for colouring cell as you desire.

I hope it helps.
 

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,388
Office Version
  1. 365
Platform
  1. Windows
Yours sounds perfect for conditionally formatted traffic light icon set if you look them up.
 

Chris Norton

New Member
Joined
Sep 16, 2002
Messages
11
Chris, Good afternoon.

You can't use conditional formating to give back answers than a cosmetic effect.

1) Use some function to give you the text answers. (IF, VLOOKUP, CHOOSE+MATCH etc)

2) Create rules at conditional formating for colouring cell as you desire.

I hope it helps.
Thank you Marcillo - I appreciate your response. (y)
 

julhs

Board Regular
Joined
Dec 3, 2018
Messages
80
Office Version
  1. 2010
Platform
  1. Windows
Condition formatting can not put the word "Low" etc in the cell, it can only highlight it if it is already there.
However you can use this, which is only using the value 5,10,15 from which ever cell these values may be in
=C6<=5
=C6<=10
=C6<=15
P.S. They must be in the above order in the Condition formatting rules window. If not just highlight the rule and use the arrow keys to move its order in the list

To get the words "Low" "Medium" "High" into the cell, you are going to have to change your formula for C6
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,129,500
Messages
5,636,690
Members
416,935
Latest member
Atulcp

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top