Ask Your Question
0

How to calculate the number of cells,colored with exact background? [closed]

asked 2014-07-16 17:12:16 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-29 21:46:23.939983

1 Answer

Sort by » oldest newest most voted
1

answered 2014-07-17 00:11:56 +0200

m.a.riosv gravatar image

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.

image description

Attached a sample file.
RemarkCyrilicCells.ods

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-07-16 17:12:16 +0200

Seen: 186 times

Last updated: Jul 17 '14