I have a table called Gender that uses conditional formatting (please forgive the stereotypical colors for F and M!):
I have a table called Student Extended Data that has a field called Gender that uses the Gender table as a Lookup table. The conditional formatting from the Gender table comes accross perfectly:
Finally, I have a table called Student Master that uses a formula to pull the Gender from the Student Extended Data for each student:
[Student Extended Data].filter(thisRow.[Student Number]=[Student Number]).Gender
For some reason, when the gender is displayed by the formula, the original conditional formatting is not displayed:
Is there any way to get the formatting to come accross with the formula? Or do I have to recreate all the conditional formatting again and apply it to the formula field?