I have table with cells that should have background color by its value, that is letter in cyrilic. How to set this? And how to write formula in different cell, that calculates the number of cells, colored in the same way by one row?
Looking for a trick to get it, this one seems to work:
=LEFT(A1;1)<>CHAR(CODE(A1))
to find if the first character of the cell is not in Latin.
Doing a conditional format (Menu/Format/Conditional formatting) with that condition looks fine. Set up the same cell address than the first for the range to set up the condition.
Attached a sample file.
RemarkCyrilicCells.ods
Looking for a trick to get it, this one seems to work:
=LEFT(A1;1)<>CHAR(CODE(A1))
to find if the first character of the cell is not in Latin.
Doing a conditional format (Menu/Format/Conditional formatting) with that condition looks fine. Set up the same cell address than the first for the range to set up the condition.
Attached a sample file.
RemarkCyrilicCells.ods