Replacing cells that contain a particular value with a symbol

flyngcoln

New Member
Joined
Nov 10, 2017
Messages
8
Hi,
I'm trying to work out how to get a symbol to pop up in a cell when two other cells contain a certain value.

For example:

If A1 and B1 contain x and y combination, C1 has a rule attached that inserts a particular symbol or text (doesn't matter what) for that particular combination.

I'm trying to make an achievement matrix interactive by entering in achievement scores (in separate cells to the matrix) that I have already placed a rule on to categorise according to a pre set range. When the combination of these two data point are entered, I then want a symbol to pop up on the matrix to indicate where the two scores have put them.

I hope that makes sense
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Level[/TD]
[TD]1BB[/TD]
[TD]1B[/TD]
[TD]2BB[/TD]
[TD]2B[/TD]
[/TR]
[TR]
[TD]2A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2AA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1AA[/TD]
[TD]:crash:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Score A[/TD]
[TD]1AA[/TD]
[/TR]
[TR]
[TD]Score B[/TD]
[TD]1BB[/TD]
[/TR]
</tbody>[/TABLE]

For example. The user has entered in their achievement scores in the table below the matrix. I have already placed a rule on the table to automatically convert the score to a level on the matrix. Now what I want to do is be able to automatically indicate where on the matrix this score correlates to. With a symbol, or text, or whatever - that bit doesn't matter so much, it could even be a #.
So for the sake of this example, you can see the indicator in the table with a :crash:
It may not even be possible.
 
Last edited:
Upvote 0
Maybe something like this in B2:
Code:
=IF(AND($B$8=$A2,$B$9=B$1),CHAR(8),"")
copied across and down to cover B2:E5. $B$8 is Score A and $B$9 is Score B. Format B2:E5 bold, red.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,224,820
Messages
6,181,161
Members
453,021
Latest member
Justyna P

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
Back
Top