Conditional formatting of two separate columns

[tbilderbac]

I have two columns, one for dates [finding the last 20 dates] and one for differentials [finding the lowest 10 differentials for those 20 dates] and we have figured that part out and it is working [Formula: =AVERAGE(INDEX(SORT(INDEX(SORT(((Sheet2!F$18:F$38):(Sheet2!$AB18:$AB38)),1,-1),SEQUENCE(20),2),,1),SEQUENCE(10)))] . Now I want to use conditional formatting to highlight the 20 dates [in one column] and then in another column [not next to the date column] I want to highlight the 10 differentials. But I am getting the following warning

How might I format the column so highlight the 20 dates and also highlight the 10 diffs. The columns are not next to each other so I cant highlight the whole row. I will need to have two formulas [or maybe 1] and create two rules.

 

[marissa2]

I can't help you with the formula IN conditional formatting. CF and I argue a lot about how things should be done. However, I have found that helper columns will do in a pinch. If regular formula works, then 1 else 0. Then use CF to highlight the cells you want based on the results of that helper column. It's not elegant, but it works.