Hi, E.

Sorry to disappoint you, but at this time, something like that is not possible with our current capabilities.

1. When we set up the condition for a row,

we need to give it a fixed value, it is not possible to give it a placeholder such as VAR1 and similar.

But it is an interesting idea for future development.

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

2. Unfortunately, this is also not possible.

With our Conditional Formatting, at this time it is only possible to look at cells in the column that the condition is being set on,

it can not look in other columns.

And it is also not possible to give it a condition such as to look for the calculation function, as you said,

for example, if it is the highest in the column.

For numeric and date columns this can be “less than”, “less than or equal”, “equal”, “not equal”, “greater than or equal”, “greater than”. For string columns this can be “equal”, “not equal”, “contains”, “does not contain” for fuzzy comparisons,

as we pointed out on our Conditional Formatting Documentation.

But you can also add a feature suggestion for this, and our devs will do their best to add a solution in the future.