Format entire row if a particular cell in the row is not empty
For illustration assuming “whole row” is ColumnsA:Z inclusive, please try Format – Conditional formatting…, Custom formula is: =$C1<>”” with formatting of your choice and Range: A:Z.
gs-conditional-formatting
Automatic colouring of a specific value wherever found in a table [closed]
In the dropdown menu, Format->Conditional formatting… Then set your rules and your color. You can select multiple cells and do this also. Edit: That is the extent of what you can do with coloring. You can maybe find a complex formula to find the minimum of the cells, and then if that matches what is … Read more
Script to Change Row Color when a cell changes text
//Sets the row color depending on the value in the “Status” column. function setRowColors() { var range = SpreadsheetApp.getActiveSheet().getDataRange(); var statusColumnOffset = getStatusColumnOffset(); for (var i = range.getRow(); i < range.getLastRow(); i++) { rowRange = range.offset(i, 0, 1); status = rowRange.offset(0, statusColumnOffset).getValue(); if (status == ‘Completed’) { rowRange.setBackgroundColor(“#99CC99”); } else if (status == ‘In Progress’) … Read more
How to address the current cell in conditional format custom formula?
The current cell is addressed by the first cell of a range in the conditional formatting. In your example, the range is A4:M10 and therefore you can use A4 as “current cell”. Check for empty content: =A4=”” Relative vs absolute references in conditional formatting work just like copying a formula. Check that the cell in … Read more
How can I copy a conditional formatting from one document to another?
If you want to copy conditional formatting to another document you can use the “Copy to…” feature for the worksheet (click the tab with the name of the worksheet at the bottom) and copy the worksheet to the other document. Then you can just copy what you want from that worksheet and right-click select “Paste … Read more