Can conditional formatting work

English
,
#1

How will conditional formatting work on this.

I have a number, see Amount 0.000000128 in A2

This number can change every few minutes

In the data below, I want the columns and rows to change to red when the number is +100 (0.00000228 or -100 0.00000028.

Amount 0.000000128

1 0,00000001 0,00000002 0,00000003 0,00000004 0,00000005 0,00000010 0,00000020 0,00000030
2 0,00000002 0,00000004 0,00000006 0,00000008 0,00000010 0,00000020 0,00000040 0,00000060
3 0,00000004 0,00000008 0,00000012 0,00000016 0,00000020 0,00000040 0,00000080 0,00000120
4 0,00000008 0,00000016 0,00000024 0,00000032 0,00000040 0,00000080 0,00000160 0,00000240
5 0,00000016 0,00000032 0,00000048 0,00000064 0,00000080 0,00000160 0,00000320 0,00000480
6 0,00000032 0,00000064 0,00000096 0,00000128 0,00000160 0,00000320 0,00000640 0,00000960
7 0,00000064 0,00000128 0,00000192 0,00000256 0,00000320 0,00000640 0,00001280 0,00001871
8 0,00000128 0,00000256 0,00000384 0,00000512 0,00000640 0,00001280 0,00002560 0,00003840
9 0,00000256 0,00000512 0,00000768 0,00001024 0,00001280 0,00002560 0,00005120 0,00007680

#2

What “+100” and “-100” means?

#3

It means that any number below can be 0.000000228 (100 more) than the amount Amount 0.000000128 or it can be 0.00000028 (100 less than Amount 0.000000128 hope this make sense

So not 100, but 0.00000100? And what if it will get 0.00000101 more or less? i.e., is that exactly that more/less, or at least that more/less? and which columns should change to red? all? or some (with such a number)?

#4

If it Amount is 0.00000128, then the others must be 0.00000228 or 0.00000028, only with 0.00000100, not more not less.

#5

Maybe this is what you need - but it is based on wild guess: I read your question like

I have a matrix of numbers; also I have a reference number. When some number in the matrix differs from the reference number exactly by 0.00000100, the whole row and column of the matrix that contain the number should become red.

And of course, this uses comparison with epsilon.

#6

sorry

It means that any number below can be 0.000000228 (100 more) than the amount Amount 0.000000128 or it can be 0.00000028 (100 less than Amount 0.000000128
hope this make sense

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.