Highlight row based on tagname(list)

hailstorm

New Member
Joined
Sep 14, 2019
Messages
34
Hello there,

This should be something ease but for some reason it's not working. In my spreadsheet i have two sheets, Sheet1 where i want the rows to highlight and Sheet2 where i created a tag name ( list ) called "test".
I'm using conditional formatting to do that, it works only when i type a word in the cell, when i put a number, which is what i want, it doesn't work.

in conditional formatting i tried ="test" ; =$A1="test" and nothing seems to work, the only time that it worked was when i changed to =$A1="b", and then i typed "b" in the cell and it worked.

What am i doing wrong?
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,623
Office Version
  1. 2007
Platform
  1. Windows
Try this:

1. Select Sheet1
2. Select the cells where you want to apply the CF
3. Put the formula in CF without quotes
=A1=test

I suppose in Sheet2 some cell has the named range: test
 

hailstorm

New Member
Joined
Sep 14, 2019
Messages
34
Try this:

1. Select Sheet1
2. Select the cells where you want to apply the CF
3. Put the formula in CF without quotes
=A1=test

I suppose in Sheet2 some cell has the named range: test

Thanks for the reply.
I renamed the list to localizar.
Put the formula in Cf without quotes it worked, but only for the first number of the list. What seems to be the problem?
I had to add "$" because otherwise it would only highlight the cel.

CF.JPG
 
Last edited:

hailstorm

New Member
Joined
Sep 14, 2019
Messages
34
Ok, i got it, searched a little bit on the internet and i found the solution to my problem.

=MATCH($A1, List, 0)

MATCH did the work with the list. THanks.
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,623
Office Version
  1. 2007
Platform
  1. Windows
I'm glad to hear that it already works for you.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,446
Messages
5,642,204
Members
417,261
Latest member
andrewd1

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