Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all.
I have a field in one Excel workbook called ID Number and, in a separate workbook that I have loaded, I have 5 columns with various headings whose data may contain matching numbers found in the ID Number column of the first workbook.
I have a straight table that includes the ID number on my dashboard. What I am trying to do is highlight any ID number that matches data in one of the specific columns in the second workbook.
In Background Color Expression for ID Number, I have this:
=IF(wildmatch([ID Number],[Appt]), Black(),RGB(255,192,0))
The field [APPT} is one of the columns in the second workbook that I am trying to find matches for in the ID Number field. I know there are several matches; however, none of those change color to the black background. All of the backgrounds stay the orange RGB color. I also tried using the IF statement with match and without either match or wildmatch as well. Any ideas?
Try the P() function,
if (count({1<[ID Number]=P([Appt])>} [ID Number]) > 0,Black(),RGB(255,192,0))
Try the P() function,
if (count({1<[ID Number]=P([Appt])>} [ID Number]) > 0,Black(),RGB(255,192,0))
You are my hero! Thank you, that worked perfectly.