Compound Logic Cell Highlighting???

[dpb]

I've a check column that two columns, same row are equal that's the
logical T/F value...that's ok, but be nice if it were highlighted or
otherwise more obvious when they don't match. That part is trivial...

The reason for the Q? is, there's also a check sum most often a long
ways removed from current location; it's possible if make a typo
somewhere for that sum to be nonzero while the two local columns agree.

It would be nice if could combine the two conditions -- highlight if the
two columns are FALSE or the other checksum is <>0.

Right now I keep going to the other location to see, but that's a bother
since _most_ of the time it is; it's just that if don't happen to catch
it when it does happen (and most often, it's because did something
accidental) it's a real pain to backtrack and repair the cause.

I couldn't figure out how to do it w/ the conditional formatting
tool...it's a confusing mess now compared to what I remember from years ago.

--

[splot!]

If I have long columns of true/false checks I always put an AND() at the top of the column to highlight if any of the cells has a FALSE result. If the two columns are far apart you could have an AND() somewhere readily visible with the results of those two cells.

Mo

[dpb]

On 10/3/2020 4:28 AM, splot! wrote:
> If I have long columns of true/false checks I always put an AND() at the top of the column to highlight if any of the cells has a FALSE result. If the two columns are far apart you could have an AND() somewhere readily visible with the results of those two cells.
>

... snip ...

That's a clever idea but doesn't really change use -- if the column is
long and you're working somewhere away, still have to move to the top to
see the flag cell...


--

[Claus Busch]

Hi,

Am Fri, 2 Oct 2020 11:07:17 -0500 schrieb dpb:

> I've a check column that two columns, same row are equal that's the
> logical T/F value...that's ok, but be nice if it were highlighted or
> otherwise more obvious when they don't match. That part is trivial...
>
> The reason for the Q? is, there's also a check sum most often a long
> ways removed from current location; it's possible if make a typo
> somewhere for that sum to be nonzero while the two local columns agree.
>
> It would be nice if could combine the two conditions -- highlight if the
> two columns are FALSE or the other checksum is <>0.
>
> Right now I keep going to the other location to see, but that's a bother
> since _most_ of the time it is; it's just that if don't happen to catch
> it when it does happen (and most often, it's because did something
> accidental) it's a real pain to backtrack and repair the cause.

I hope I understood your problem correctly.
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTge8ypnLNeJgW6dbwIQ?e=MoVqPw


Regards
Claus B.
--
Windows10
Office 2016

[dpb]

Couldn't figure out how to use the web thingie to put something that
illustrates where you could get to it...I can see and open that, but it
only writes to local disk if I edit and try to save.

Don't use the web stuff; there's a mapped network drive that has all the
Foundation files we use. So, don't know my way around web stuff at
all...sorry.

--

[Claus Busch]

Hi,

Am Sun, 4 Oct 2020 08:40:21 -0500 schrieb dpb:

> Couldn't figure out how to use the web thingie to put something that
> illustrates where you could get to it...I can see and open that, but it
> only writes to local disk if I edit and try to save.
>
> Don't use the web stuff; there's a mapped network drive that has all the
> Foundation files we use. So, don't know my way around web stuff at
> all...sorry.

you can send me an email