Conditional format "match range"
Solved/Closed
Netscur
Posts
21
Registration date
Thursday July 23, 2009
Status
Member
Last seen
April 6, 2012
-
Aug 10, 2010 at 10:27 AM
SadBingoDude - Jan 24, 2019 at 03:08 AM
SadBingoDude - Jan 24, 2019 at 03:08 AM
Related:
- Conditional format "match range"
- Format factory - Download - Other
- Music match jukebox - Download - Audio playback
- Excel date format dd.mm.yyyy - Guide
- Kingston format utility - Download - Storage
- Samsung format code - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 10, 2010 at 02:42 PM
Aug 10, 2010 at 02:42 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
Aug 11, 2010 at 10:15 AM
This is a single worksheet.
Column A represents the 'bingo numbers drawn' (in theory the match range should be for $A:$A as it could be ever expanding).
In cells C3: G25 are three templates for `bingo cards'. I expect a user would have to enter their numbers in manually until I wrote the program to send out electronic cards.
The only method I could construct to make this objective functional was to duplicate the `card data' in cells J3:N25. Then I used a simple MATCH formula to lookup if the number was drawn (found in column A). If it is found/true the cell space will be populated with an "X" or left it blank if the lookup criteria is false.
I am missing something basic or simple to make this concept function without duplicating the card templates. Your expertise is appreciated.
Aug 11, 2010 at 10:24 AM
IF you hightlight range C3:G7 and put this as conditional format
=AND(C3<>"", NOT(ISERROR(MATCH(C3,$A:$A,0))))
Aug 11, 2010 at 01:17 PM
Oct 21, 2013 at 06:43 AM
Thanks!
Jan 24, 2019 at 03:08 AM