## google sheets – Conditional formatting cells with multiple conditions and relative references across a range

I have a Google spreadsheet with arbitrary data. Three adjacent columns (for example, A, B, and C) have been set up to allow only values ​​from 1 to 10 during data validation.

I am looking for a way to check if all three columns of a single row (for example, A4, B4, and C4) have a value of 10 and all three cells should be formatted differently.

This formatting should apply to a full range from A / B / C1 to A / B / C300, and this is the problem.

I've tried many ways to do that with data validation, built-in functions, and conditional formatting, but apart from using the formatting on a line-by-line basis, I have not found a really effective way to do it. Had to resort to the script editor and write a function called when onEdit () is triggered, but this is slow and the coloring is actually applied when the code is triggered because each line must be checked individually.

Is there a way to do this without having to resort to scripts and without having to do it line by line?

## Conditional Formatting – Is it possible to override / display non-heatmap related data through an Excel Range Heatmap? & # 39;

Is it possible to overlay / display data from a similarly shaped matrix over an area heatmap instead of simply showing / hiding the underlying heatmap data?
The question could also be worded differently: Is it possible to have a heatmap for a particular range (eg, "A1: C3") based on a range of data elsewhere on the sheet (eg, "F1: H3")? ) to generate? If so, you could visualize the "A1: C3" values ​​via the heatmap. The goal here is simply to get the heatmap to see more information …

## html – javascript difficulties calculations and currency formatting

I am developing a project and have difficulties for a long time. I hope you can help me. I do not have much knowledge in JavaScript or JQuery.

In short:
I'm creating a budget record form and need to sum the values ​​of a particular column of a table and assign them to a field I've set as a subtotal. Later, this value is used to calculate a discount that can be assigned under "Fixed value" or "%", which leads to what I have determined as total.

It's worth noting that the fields in the table are generated dynamically with javascript, and that I would somehow have to store each line and their respective fields in order to later upload them to a database when dealing with values ​​in "R $" I have a lot of trouble formatting and doing the calculations while my currency mask is working.  // currency mask Function currency (i) { var v = i.value.replace (/ D / g, & # 39; & # 39;); v = (v / 100) .toFixed (2) + "; v = v.replace (".", ","); v = v.replace (/ ( d) ( d {3}) ( d {3}), / g, "$ 1. $2.$ 3,");
v = v.replace (/ ( d) ( d {3}), / g, "$1.$ 2,");
i.value = "" + v;
}

// budget page
$(document) .ready (function () { var counter = 0; // Add new line$ ("# addLine"). On ("click", function () {
counter ++;

var newRow = $(""); var cols = ""; cols + = & # 39;& # 39 ;; cols + = & # 39;& # 39 ;; cols + = & # 39;& # 39 ;; cols + = & # 39;& # 39 ;; cols + = & # 39;& # 39 ;; newRow.append (cols);$ ("# table_levels") append (newRow);

});

// Function call to calculate the sum of each line
$("# table_levels"). on ("blur keyup", & # 39; input[name^="orcamento_item_valor"], Input[name^="orcamento_item_qtd"]& # 39 ;, function (event) { calculateSeries ($ (this) .closest ("tr"));
});

// remove line
$("# table_levels") on ("click", "a.deleteLinha", function (event) {$ (this) .closest ("tr"). remove ();
});
});

// function to calculate the sum of each line
Function calculate line (line) {
var price = + row.find (& # 39; input[name^="orcamento_item_valor"]& # 39;) .val ();
var quant = + row.find (& # 39; input[name^="orcamento_item_qtd"]& # 39;) .val ();

// 2 decimal places
var tot = (price * quant) .toFixed (2);
// replace the point with a comma
// The regex at the bottom places one point to the left of each group of 3 digits because it is not at the beginning of the number
For example, if you want to change the row determination (& # 39 ;, Total & # 39;). Html ("R $" + (dead) .replace (/ B (?)); var v_total = (dead) .replace (/ B (? = ( d {3}) + (?! d)) / g, ".");$ ("#increment_item_subtotal"). val (v_total);
}



General data

Name of the customer / pre-client: *

Responsible Officer:

Status: *

Choose
Pending
Approved
Canceled

Opening Date:

Opening hours:

time:

Budget remark:

budget item

Product / service
unit value
amount
value
commands

Subtotal:

Type of description:

Choose
% Percentage
R \$ fixed value

Discount:

Total:



## Worksheet function – Excel formula with conditional formatting

I use data in my spreadsheet and want to display a date that should be highlighted when it is 18 months larger than another cell. If it is 18 months smaller than another cell, if it is between 9 and 12 months of another cell, I would like to highlight it.

So for example
Cell A1 = 2/1/2019
Cell B1 = 7/1/2020

I want cell B1 to be green if it is 18 months or more than cell A1

I want B1 to be blue if it's between 15 and 17 months less than cell A1

I want B1 to be yellow if it's 14 months or less than cell A1

Hoping you can help please.

## String with number output formatting

Thank you for your reply to Mathematica Stack Exchange!

• Please be sure too answer the question, Provide details and share your research!

But avoid

• Ask for help, clarification or answering other questions.
• Make statements based on opinions; Cover them with references or personal experience.

Use MathJax to format equations. Mathjax reference.

For more information, see our tips for writing great answers.

## vba – Conditional formatting and cell color

I conditionally formatted cell A1 if it now turns red
I want B1 to say red

I have the following code, but it does not work on conditionally formatted cells

Function CheckColor1 (area)
If range.Interior.Color = RGB (255, 0, 0), then
CheckColor1 = "Red"
ElseIf range.Interior.Color = RGB (0, 176, 80) Then
CheckColor1 = "Green"
Otherwise
CheckColor1 = "Amber"
End If
End function


## Javascript – Pascal's Triangle JS formatting

For my code up to the fifth line, the formatting of my triangle is fine. But once I've reached the sixth row, the formatting gets weird because I'm double-digit. Is there a way to fix this?

Is my code optimized too? How can I do better?

Many Thanks!

function pascals (num) {
var result = [[1],[1,1]];

if (num === 0) {
console.log (0);
}

if (num === 1) {
console.log (1);
}

miscellaneous
for (var i = 2; i <num; i ++) {
Result[i] = [];
Result[i][0]    = 1;

for (var j = 1; j <i; j ++) {

Result[i][j]    = Result[i - 1][j - 1]    + Result[i - 1][j];
}
Result[i][j]    = 1
}
}
for (var i = 0; i <result.length; i ++) {
console.log (& # 39; .repeat (result.length - i) + result[i]);
}
}

Pascal (6)

                        1
1.1
1,2,1
1,3,3,1
1,4,6,4,1
1,5,10,10,5,1


## Formatting – sSheet DateTime format

I use AppSheet to create a timesheet app, and in the app I have to use the DateTime format to calculate overtime and regular hours correctly.

My gSheet DateTime format returns a start date of "30.12.1899" instead of the Now date. How can gSheet capture the date from the app instead of returning the 1899 date?

## Recovery Mode – Decryption Unsuccessful after deleting and formatting data

P9 Lite, everything was fine until I was upgraded from Magisk 18 to 19.1 in the evening

The decryption error failed, the Magisk Uninstaller was flashed, Data + Cache + Dalvik was deleted, and the data format of TWRP was tried. Nothing worked.

I'm going on a trip tomorrow, so I need to be able to use the phone as soon as possible.