Conditional borders in Google SpreadSheet
*EDIT*
Thank you for clarifying! Here are some quick edits to the script to make it run on sheet of arbitrary row and columns, format the cell with the largest value with a medium weight yellow border. Threw this together quickly, but I hope it helps!
function JKHAScript() {
//get the first sheet of the currently active google spreadsheet
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var NumRows = sheet.getMaxRows();
var NumColumns = sheet.getMaxColumns();
//loop through each column skipping the first row, (j,i) is the (row#, column#)
for (let i = 1; i <= NumColumns; i++) {
var LargestCell = sheet.getRange(2,1);
for (let j = 2; j <= NumRows; j++) {
let IndexCell = sheet.getRange(j, i);
//one pass through each column, grabs the largest value
if (IndexCell.getValue() > LargestCell.getValue()) {
LargestCell = IndexCell;
}
}
//after pass, the cell with the largest value gets the border formatting
LargestCell.setBorder(true,true,true,true,null,null, "yellow", SpreadsheetApp.BorderStyle.SOLID_MEDIUM)
}
}
To run a script over a google sheet: open your sheet, go to the tools tab, click the scripts editor. Only paste code you trust into the editor!! Click run at the top of the page to execute the script on whatever sheet you had currently open. Should look something like this:
*ORIGINAL*
Forgive me if I misunderstand, but I believe your issue can be solved using google app scripts. I am not sure exactly what formatting you want to perform but here is a simple example that runs on a little 11 by 4 sheet with random numbers. Of course, you will need to modify it to work on your sheet, and perform whatever formatting you wish to apply.
function JKHAScript() {
//get the first sheet of the currently active google spreadsheet
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
//loop through each column skipping the first row, (j,i) is the (row#, column#)
for (let i = 1; i <= 4; i++) {
var LargestCell = sheet.getRange(2,1);
for (let j = 2; j <=11; j++) {
let IndexCell = sheet.getRange(j, i);
//one pass through each column, grabs the largest value
if (IndexCell.getValue() > LargestCell.getValue()) {
LargestCell = IndexCell;
}
}
//after pass, the cell with the largest value gets the border formatting
LargestCell.setBorder(true,true,true,true,null,null, "yellow", null)
}
}
Before running
After running
This is a slow and lame example. You can find more information about google app scripts here. Good luck scripting my friend!