1. Messages
  2. Set colour with conditional rule in Excel 2016

Re: Set colour with conditional rule in Excel 2016

Cearbhall O'Meadhra
 

Brian,

 

This is excellent! I followed your steps and it worked exactly as you describe. The trick is to arrow right until the white comes around second time, as you say. I then pressed up or down-arrow until the variant of my colour came up.

 

I did have the three RGB colour values from a previous setting that a sighted person had selected so I watched out and they came up under the up and down arrow process.

 

When I tab away from the first element that shows “no colour”, There are four other buttons:

Fill Effects...

More Colors...

Pattern Color Automatic

Pattern Solid Pattern control

 

And then, finally, OK

 

Have you any experience of using these other tabs? What did you have to do to be sure that you could accurately detect what was selected?

 

All the best,

 

Cearbhall

 

m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@...

 

 

From: nvda@nvda.groups.io <nvda@nvda.groups.io> On Behalf Of Brian Vogel
Sent: Thursday, August 23, 2018 12:20 AM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Set colour with conditional rule in Excel 2016

 

Cearbhall,

           I can set it, and NVDA is announcing the color when I select it from the grid that's presented.  I did not try the "More Colors" button.

           Be aware that the first button on the "Fill" tab is "No Color" and it's always there, and first, in case you want to clear any color that you may previously have used.  After you select the color you want, the "No Color" button is still there and prominently featured.  Once you land on the No Color Button, you must right arrow through the first set of colours, which start with white, and when you hear white again you're in the grid where you can down/up/left/right arrow your way around.  It may be easier to avoid all this altogether if you know the RGB value for the background color you wish to use.  If that's the case, go directly to the "More Colors" button and activate it, then if you're not already on the custom colours tab of the More Colors dialog, navigate to it.  The default color model is RGB and you can then get to the red, green, and blue edit boxes and enter the values for the background color you want, and hit OK.

But even if I used NVDA with the color selection toolbar/grid, as soon as I right arrowed off of the "No Color" button NVDA began announcing the colours and their respective RGB values, and allowing me to select the one I was currently on.
--

Brian - Windows 10 Home, 64-Bit, Version 1803, Build 17134  

    A little kindness from person to person is better than a vast love for all humankind.

           ~ Richard Dehmel

 

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