moderated Re: Ideas for handling color coded spreadsheets
Van Lant, Robin
Thanks for the ideas. I’m going to play with using the Find Command, Filtering and other suggestions. I am new to using the JAWS speech Schemes and see how this works well in Word, but I’m not getting them to work in Excel. That might have been really helpful and maybe I’ll find a way to get it to work.
I’ll type up some questions and also call Microsoft Accessibility to see if they have any ideas. It doesn’t’ help that there are just so many colors available in Office products. The file I got from a coworker last week is using a background color called Khaki1. She suggested that I could update the cells I edited, but I’m not even sure how to find this color when I need to fill appropriate cells. I think I’ll ask some of the executive assistants around here for tips. Even without the blindness aspect, maybe I can gain some best practices and tricks that might make my work easier when I need to add colors to a file.
From: firstname.lastname@example.org <email@example.com> On Behalf Of David Goldfield
Sent: Thursday, February 13, 2020 8:02 PM
Subject: Re: Ideas for handling color coded spreadsheets
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.
Blindness Assistive Technology Specialist
JAWS Certified, 2019
On 2/13/2020 4:24 PM, Van Lant, Robin via Groups.Io wrote: