Answer the question
In order to leave comments, you need to log in
How to perform cell formatting comparison?
Test spreadsheet:
https://docs.google.com/spreadsheets/d/1EsPJvcxVbr...
How can I compare the formatting of a particular cell with a possible value?
For example, cell A1 has specific formatting (cell background, bold, etc.). The standard has the same formatting - cell D2
How to display the result of cell comparison with the standard in cell B8?
For example, if the background color changes in A1, the design will no longer correspond to the standard (cell D2) and in B8 it should become FALSE
Answer the question
In order to leave comments, you need to log in
"Out of the box" - no way. You can write a comparison script for one or more formatting options, there are enough of them. There are also Rich values in cells - there may be different formatting for different pieces of content.
See parameters and compare using ===
Range. getBackground
() -
Range background color . getFontColor
() -
Range text color . getFontWeight () - text weight
, etc.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question