For the first part of this question consider the following dataset
as an example:
dataset=ExampleData[{"Dataset","Titanic"}][[;;20]];
Suppose I want to highlight the ages above 30 in the second half of this dataset. I can achieve it using the following command:
Dataset[dataset,Background->(If[First@#2>10&&Last@#2=="age"&>30,LightYellow]&)]
But if I try it using the part like syntax I can't get it to work.
Dataset[dataset,Background->{{11;;,"age"}->(If[#1>30,LightYellow]&)}]
Please help me find the shortest syntax to achieve this!
Next, suppose I also want an additional constraint that gender should be female. So the output should be like that from the following command.
Dataset[dataset,Background->(If[MemberQ[{18,19},First@#2]&&Last@#2=="age"&>30,LightYellow]&)]
For the second part of this question consider the following dataset
as an example:
--- I will wait for an answer to the first part because maybe then the second part will follow from the first ---