David Goldfield <david.goldfield@...>
Hi. I've never tried using JAWS to behave in a specific way when
dealing with colors in Excel but the feature works in other
programs and so I don't see any reason why it would not work in
Excel when it detects a specific color when you move to a cell
containing text in that color. I don't have enough time to
actually try it but I may experiment with it this coming weekend.
David Goldfield,
Blindness Assistive Technology Specialist
JAWS Certified, 2019
WWW.DavidGoldfield.org
On 2/13/2020 10:09 PM, Glenn / Lenny
wrote:
toggle quoted messageShow quoted text
I did not know that Jaws could be set to play a sound file
when moving into a cell of a specific color.
If so, one could make up your own WAV files saying things
like blue cell or red cell.
Glenn
----- Original Message -----
Sent: Thursday, February 13, 2020 9:02 PM
Subject: Re: Ideas for handling color coded
spreadsheets
Robin,
Please bear in mind that I have no personal experience in
dealing with color-coded spreadsheets but I believe I can get
you started on finding some possible solutions.
First, Excel's Find command, available via the ctrl-F hotkey,
contains an Options button within this dialog. When you
activate this button you will be in another dialog. From this
dialog, navigate with the tab key and look for the Format
button. Once you activate the Format button you will be in a
multi-page dialog box. One of these tabs is a Font tab. Within
the font page is a color picker, where you can specify a
specific color that you're looking for. Once you perform a
color search it is likely that activating the Find Next
command, which is probably f3, will search for the next cell
containing the color you previously searched for. Along with
that you could also use the Speech and Sounds Manager, found
within Settings Center, to set JAWS to behave in a certain way
when you move to a cell containing a specific color. As an
example, it should be possible to tell JAWS to play a certain
sound when you move into a cell containing red text or you
could have JAWS identify that color by speaking its name when
it gains focus. You can even tell JAWS to read text in a
specific color in a different voice. For red text you could
set JAWS to read it with a lower pitch voice, as an example.
The instructions in how to do this would be in the JAWS help
system and you have many options from which to choose. I wish
that JAWS would have keystrokes where you could bring up a
list of cells with specific color attributes, such as all
cells with red text. I don't believe that this capability
exists with the current set of Excel scripts. I think this is
something which FS should add and it might be worth writing to
suggestions@...
to ask them to add this. It could likely be done with
scripting.
I hope this helps.
David Goldfield,
Blindness Assistive Technology Specialist
JAWS Certified, 2019
WWW.DavidGoldfield.org
On 2/13/2020 4:24 PM, Van Lant,
Robin via Groups.Io wrote:
Hi all,
Using JAWS 2019 with Office 365 and
Windows 10.
I seem to be working with more people,
including my new manager, who really like color coding in
Excel. I totally get it, as I can clearly understand how
this visually makes looking at a large spreadsheet file
easier, especially on calendar or schedule files. The
first project I had for my new manager was to take a color
coded calendar she had from last summer and update it for
this year, color coding each event based on whether I was
able to secure the necessary room reservation. My
approach in this case was to hunt for color coded cells,
and copy the color into a place off to the side, then
clear all the colors and then paste the colors back in to
new cells as I made the room reservations. This is just
an example.
Hear my question with the lens of
someone who is losing more usable vision and adjusting to
new leadership in my role. I’m feeling a bit insecure
about my abilities and am wondering if there are any tips
from others who share spreadsheet files with sighted
colleagues on managing colors and/or fancier layouts. I’m
intimidated by these large files my new manager is
sending. I’ve typically been the one creating the
spreadsheet, so I could lay it out in my own way, but I’m
taking on new job duties and inheriting files with lots of
data that is just just a simple grid.
I guess I just need to hear of there
are any tips or empathy out there.
Robin Van Lant, Sr. Program
Manager, Strategy & Performance Management
Key Equipment Finance | 720-304-1060 |
www.keyequipmentfinance.com
This communication may contain privileged and/or confidential
information. It is intended solely for the use of the
addressee. If you are not the intended recipient, you are
strictly prohibited from disclosing, copying, distributing or
using any of this information. If you received this
communication in error, please contact the sender immediately
and destroy the material in its entirety, whether electronic
or hard copy. This communication may contain nonpublic
personal information about consumers subject to the
restrictions of the Gramm-Leach-Bliley Act. You may not
directly or indirectly reuse or redisclose such information
for any purpose other than to provide the services for which
you are receiving the information.
127 Public Square, Cleveland, OH 44114
If you prefer not to receive future e-mail offers for products
or services from Key, send an email to mailto:DNERequests@...
with 'No Promotional E-mails' in the SUBJECT line.
|