Google-sheets – Google Sheets: Conditional Coloring Based on Slope Increase (Acceleration)

conditional formattinggoogle sheets

In Google Sheets, how do you conditionally color cells based on whether the cell's value is accelerating or decelerating?

For example, in the image below, I created four columns: the time, distance, speed, and acceleration. The acceleration is just the second derivative of the distance. How would I conditionally color the background of the distance column based on the acceleration column in Google sheets? I would not like to create separate columns for speed and acceleration, instead, just relying on the distance column itself.

Best Answer

Use the Format > Conditional Formatting tool.

First, select a cell in the distance column. We want this to be red or green based on the corresponding acceleration value in the same row.

You want to use a custom formula (bottom option) and then make it read =Dx>0 See the recreation I have done. You will need to do this for each value in distance.

Related Solutions

Google-sheets – Conditional formatting based on cell values in same column

Assuming the actual finishing date is in Column F and the sheet is called Sheet1, paste the code below inside your spreadsheet under Tools >> Script editor, then hit Save.

/***
* Color Code+ 
* Conditional formatting with cell referencing for Google Spreadsheets
* Support: scripts@bryanp.com
**/

function onEdit() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = ss.getSheetByName('Sheet1');
var values1Rule1 = s.getRange('E1:E').getValues();
var values2Rule1 = s.getRange('F1:F').getValues();
var range3Rule1 = s.getRange('E1:E');
var color1 = 'red';

for (var row in values1Rule1) {
for (var col in values1Rule1[row]) {
if (values1Rule1[row][col] == values2Rule1[row][col]) s.getRange(s.getRange('E1').offset(row, col, 1, 1).getA1Notation()).setBackgroundColor(color1);
else s.getRange(s.getRange('E1').offset(row, col, 1, 1).getA1Notation()).setBackgroundColor('white'); }}
};

I used this script generator to make creating the code easier. You can adapt it to your needs.

Google Sheets – Conditional Formatting by Day of the Week

I had been struggling with this for a long time, but finally cracked it:

Use conditional formatting on the column with the dates and type the following as a custom formula:

=or(WEEKDAY(A1)=1,WEEKDAY(A1)=7)

where A1 is the first date in the column.

This will apply the conditional formatting to all weekdays with a value of 1 (Sunday) and 7 (Saturday).

Best Answer

Related Solutions

Google-sheets – Conditional formatting based on cell values in same column

Google Sheets – Conditional Formatting by Day of the Week

Related Topic