software

How do I get more than three choices for quot;Conditional Formattingquot;? I'm not a
coder in any way. I don't want to write a macro (are there any volunteers?).

All I have to do is get the format (font, cell, border) to change when I
type any specific number or name from a list so 1, 2, 3, 4 and 5 are all
different formats and Bill, John, Ted, Trixie, Bubbles and Biff are all
different formats. Those values don't have to relate to each other AT ALL
(names and numbers).

Shouldn't this be easy or do we need an engineering degree to make this
work? I know how to create quot;Pick From Listsquot; and I've done quot;VLookupsquot; (though
that wasn't fun). But I don't understand any of the following terms:

Select Case Me.txtBox
Case quot;X1quot;, quot;X2quot;, quot;X3quot;
Me.txtBox.BackColor = 255
Case quot;Y1quot;, quot;Y2quot;
Me.txtBox.BackColor = 100
Case quot;Z1quot;
Me.txtBox.BackColor = 301
Case quot;Z2quot;
Me.txtBox.BackColor = 302
Case Else
Me.txtBox.BackColor = 16777215
End Select

I don't know what any of that means. Not a single word (word?).

Thank you, thank you, thank you if you can put this into terms a simple
artist can understand!!!

Hi Adam,

How many different formats do you actually want?
Is it 5 (one for each number 1-5) plus 6 (one for each name) = 11?

Dave.quot;Adamquot; gt; wrote in message
...
gt; How do I get more than three choices for quot;Conditional Formattingquot;? I'm not
a
gt; coder in any way. I don't want to write a macro (are there any
volunteers?).
gt;
gt; All I have to do is get the format (font, cell, border) to change when I
gt; type any specific number or name from a list so 1, 2, 3, 4 and 5 are all
gt; different formats and Bill, John, Ted, Trixie, Bubbles and Biff are all
gt; different formats. Those values don't have to relate to each other AT ALL
gt; (names and numbers).
gt;
gt; Shouldn't this be easy or do we need an engineering degree to make this
gt; work? I know how to create quot;Pick From Listsquot; and I've done quot;VLookupsquot;
(though
gt; that wasn't fun). But I don't understand any of the following terms:
gt;
gt; Select Case Me.txtBox
gt; Case quot;X1quot;, quot;X2quot;, quot;X3quot;
gt; Me.txtBox.BackColor = 255
gt; Case quot;Y1quot;, quot;Y2quot;
gt; Me.txtBox.BackColor = 100
gt; Case quot;Z1quot;
gt; Me.txtBox.BackColor = 301
gt; Case quot;Z2quot;
gt; Me.txtBox.BackColor = 302
gt; Case Else
gt; Me.txtBox.BackColor = 16777215
gt; End Select
gt;
gt; I don't know what any of that means. Not a single word (word?).
gt;
gt; Thank you, thank you, thank you if you can put this into terms a simple
gt; artist can understand!!!
Hi Adam,

Perhaps xlDynamic's user-friendly CFPlus addin would help:

www.xldynamic.com/source/xld.....Download.html---
Regards,
Normanquot;Adamquot; gt; wrote in message
...
gt; How do I get more than three choices for quot;Conditional Formattingquot;? I'm not
gt; a
gt; coder in any way. I don't want to write a macro (are there any
gt; volunteers?).
gt;
gt; All I have to do is get the format (font, cell, border) to change when I
gt; type any specific number or name from a list so 1, 2, 3, 4 and 5 are all
gt; different formats and Bill, John, Ted, Trixie, Bubbles and Biff are all
gt; different formats. Those values don't have to relate to each other AT ALL
gt; (names and numbers).
gt;
gt; Shouldn't this be easy or do we need an engineering degree to make this
gt; work? I know how to create quot;Pick From Listsquot; and I've done quot;VLookupsquot;
gt; (though
gt; that wasn't fun). But I don't understand any of the following terms:
gt;
gt; Select Case Me.txtBox
gt; Case quot;X1quot;, quot;X2quot;, quot;X3quot;
gt; Me.txtBox.BackColor = 255
gt; Case quot;Y1quot;, quot;Y2quot;
gt; Me.txtBox.BackColor = 100
gt; Case quot;Z1quot;
gt; Me.txtBox.BackColor = 301
gt; Case quot;Z2quot;
gt; Me.txtBox.BackColor = 302
gt; Case Else
gt; Me.txtBox.BackColor = 16777215
gt; End Select
gt;
gt; I don't know what any of that means. Not a single word (word?).
gt;
gt; Thank you, thank you, thank you if you can put this into terms a simple
gt; artist can understand!!!