Z
Z
Zorgios2021-11-17 18:31:09
Google Sheets
Zorgios, 2021-11-17 18:31:09

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

1 answer(s)
G
Grigory Boev, 2021-11-18
@Zorgios

"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 question

Ask a Question

731 491 924 answers to any question