I've a check column that two columns, same row are equal that's theMo
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.
--
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.
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 ofthose two cells.
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
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.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 37:06:51 |
Calls: | 6,648 |
Calls today: | 3 |
Files: | 12,193 |
Messages: | 5,329,127 |