View Single Post
  #26   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default A Boolean expression

On Monday, April 27, 2015 at 4:36:48 PM UTC-7, GS wrote:
This just in,


The colour coding is due to the result of the qualification against
the position on work sheet 1 - N = Red, R = Blue.

And Y is plain black.

Howard


Hmm...

Name1 is YYR color Blue
Name2 is YY color Red
Name3 is YNR color Blue
Name4 is YY no color

..and so does not jive with your "just in"!

--
Garry


After "wringing" N = Red, R = Blue and confirming Y is no color (black of course) I asked if those were typos in the examples.

No word back yet.

It at first sounded like a committee was reviewing the data and making a decision on the color, (which has budget implications later).

I have mild confidence N = Red, R = Blue, Y = No color.

I assume if for some upshot reason R needed to be Blue, it would be a minor change in font.color = in the code.

Howard

Howard