I am trying to set up conditional formatting for my SharePoint list, based on the value from different columns.
Here is what I was trying to set up:
(1) IF @ColumnName1 = "status 4" THEN @ColumnName2 be highlighted red if the cell is blank. (2) IF @ColumnName3 = "" THEN @ColumnName4 be highlighted red if the cell is blank.
And more functions similar to them.
I have written some code, but I am not entirely sure how to create argument reference to another column. How this can be done?
Thank you in advance.