Conditional Formatting Unique Values in Same Column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I am trying to do the following -
Code:
Walmart 7011
Target 4234
Stores: ShopRite 2342
Trader Joes 7011
Apple 9902
With this data, I would want to highlight each row that doesn't contain a 'Code' value of 7011 or 2342. This would highlight the 'Target' and 'Apple' rows. My data is stored as a string, and I have tried using conditional formatting for my basic table. When doing so, I can only call out one value in my != function and the formatting ignores the rest, so I've been stuck only highlighting one code. If this doesn't make sense I can explain more, but essentially I want to highlight every code's row that isn't equal to the codes I am looking for in my basic table.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@mfranchino21 One way of doing this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What if I wanted to the opposite, and highlight what isnt what i want. Would I need to change the 'contains'? I asked my initial question backwards, I want to highlight what isnt what I want, but i wont know all variables incoming, i will only know the ones i want, and i want to highlight the ones i dont.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I tried !Contains and couldnt get it as well
