Re: determining the color of a text in Excel with NVDA


Jonathan COHN
 

Hello,
Well, negative numbers can be represented visually many ways and nno matter how they are displayed if the formulas are going to work they need to be negative numbers.

Some possibilities: look at the "filter special" functionality there you can filter by color or value. i.e. only shows rows where Column C is red or where column c has a value less than 200.

Although my understanding of Excel filters is very limited, I have only been able to create filters for specific columns in a table, not the entire table or row values which could be useful in this case.

2. Change numeric cell formatting there is a grid to select a format for negative numbers. You should be able to do this unless the sheet creator
3.Search functionality [appears to be a not possible]locked down formats.

I would have expected that with all the mathematical word done in Excel that one could search by numerical values, but I did not see an option to find the next cell with value < a specific number.
4. Pose the problem to the Microsoft accessibility desk. I can't believe you are the first person to encounter RED negatives and not been able to find them.


On 10/18/18, 2:35 AM, "nvda@nvda.groups.io on behalf of Brian's Mail list account via Groups.Io" <nvda@nvda.groups.io on behalf of bglists=blueyonder.co.uk@groups.io> wrote:

Yes which is why I'd want to know, not by a stupid colour but by a minus
sign.
Brian

bglists@blueyonder.co.uk
Sent via blueyonder.
Please address personal E-mail to:-
briang1@blueyonder.co.uk, putting 'Brian Gaff'
in the display name field.

----- Original Message -----
From: "Brian Vogel" <britechguy@gmail.com>
To: <nvda@nvda.groups.io>
Sent: Thursday, October 18, 2018 12:14 AM
Subject: Re: [nvda] determining the color of a text in Excel with NVDA


On Wed, Oct 17, 2018 at 06:53 PM, Joseph Lee wrote:

>
> Fixing this will require

. . . making any negative number be announced as negative, regardless of
what anything else says.

Math is math, and positive is positive and negative is negative and ne'er
the twain shall be the same. It is essential that anyone working with
numeric values knows the actual value of said numbers.

--

Brian *-* Windows 10 Home, 64-Bit, Version 1809, Build 17763

*The terrible state of public education has paid huge dividends in
ignorance. Huge. We now have a country that can be told blatant lies —
easily checkable, blatant lies — and I’m not talking about the covert
workings of the CIA. When we have a terrorist attack, on September 11, 2001
with 19 men — 15 of them are Saudis — and five minutes later the whole
country thinks they’re from Iraq — how can you have faith in the public?
This is an easily checkable fact. The whole country is like the O.J. Simpson
jurors.*

~ Fran Lebowitz in Ruminator Magazine interview with Susannah McNeely
(Aug/Sept 2005)

Join nvda@nvda.groups.io to automatically receive all group messages.