I need assistance with this excel issue.
I have a worksheet that has a column with ID's another with Courses Taken.
The same ID can be found multiple times in column A. I need to highlight when a specific ID has not taken a specific course (Ex AAA100)
any advice on which way I should tackle this? conditional formatting does not seem to be the choice... but a IF AND type thing.
Perhjaps, conditional formatting with formula to determine the same..
With IDs in Column 'B', Courses taken in Column 'C'
For Cell B1 use ..
and so on
Please Login or Register to view this content.
Life's a spreadsheet, Excel!
Say thanks, Click *
With your ID's in A1:A40, Course ID's in B1:B40 and your course you want specifically to look up in E1
Selecting A1:B40
Conditional Formatting>New Rule>Use Formula
=COUNTIFS($B$1:$B$40,$E$1,$A$1:$A$40,$A1)=0
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
close... but not quite there
The ID and course are highlighted(unfortunately so are some courses that are much different than the one in E1)... the course has 2 potential wildcard letters as part of it. (Ex AAA100FA or AAA100FB). In your formula I have to choose a specific one.(Sorry I realize I wasnt clear about that before).
Appreciate the assistance on this one!
I have attached a file that shows how I would like the ID to be highlighted if they have not taken a AAA200 course
Selecting A2:A10
Conditional formula
=COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,$E$1&"*")=0
YES! that works great! thanks a lot. Did not think conditional formatting was the way but was i wrong
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks