Excel, Here is a teaser for me

Here is a teaser for me

Author	Message
James Schmid #1 / 6	Here is a teaser for me How do you make a cell turn yellow if the amount of characters ( not numbers ) in the cell = 8 and blue if cell = 6 example #2813913 = color yellow example #31967 = color blue I have used conditional programming in the past, but only referenced numbers or formulas, not characters. -- Thank you, James P. Schmidt
Thu, 08 Jul 2004 12:41:03 GMT

Peo Sjoblo #2 / 6	Here is a teaser for me James, format>conditional formatting in the formula is box put =LEN(TRIM(A1))=8 click the format button, select patterns and colour red, click add and formula is =LEN(TRIM(A1))=6 click the format button, select patterns and blue, click OK. -- Regards, Peo Sjoblom Quote: > How do you make a cell turn yellow if the amount of characters ( not > numbers ) in the cell = 8 > and blue if cell = 6 > example #2813913 = color yellow > example #31967 = color blue > I have used conditional programming in the past, but only referenced numbers > or formulas, not characters. > -- > Thank you, > James P. Schmidt
Thu, 08 Jul 2004 11:59:35 GMT

Brian Pruit #3 / 6	Here is a teaser for me You can use conditional formatting. Use the Formual Is and use the following formula, =LEN(A1)=8 Once you set this conditional format for a single cell, just select the range you want to apply it to. Select Conditional Formatting again, and click Ok. HTH, Brian Quote: > How do you make a cell turn yellow if the amount of characters ( not > numbers ) in the cell = 8 > and blue if cell = 6 > example #2813913 = color yellow > example #31967 = color blue > I have used conditional programming in the past, but only referenced numbers > or formulas, not characters. > -- > Thank you, > James P. Schmidt
Thu, 08 Jul 2004 12:09:11 GMT

James Schmid #4 / 6	Here is a teaser for me Can I code a condition that will change color of text in column "a" that does not match items in column "d" To Turn Red Conditional formatting will not work for this because if true it sets the background color to the unwanted color, and if I select a color for this argument, and it ends in false, then again I end up with the wrong color. I think code is probably the route, Any insight would be helpful Thanks again James Schmidt
Thu, 08 Jul 2004 13:39:10 GMT

Brian Pruit #5 / 6	Here is a teaser for me James, The following formula can be pasted in the conditional formatting dialog. Select the range you want to apply it to first. Adjust the addresses to your needs. =ISNA(MATCH(A1,B$1:B$12,0)) The Match will return #NA error if it does not find a match, thus ISNA will return True. And your format will be applied. HTH, Brian Quote: > Can I code a condition that will change color of text in column "a" that > does not match items in column "d" To Turn Red > Conditional formatting will not work for this because if true it sets the > background color to the unwanted color, and if I select a color for this > argument, and it ends in false, then again I end up with the wrong color. > I think code is probably the route, > Any insight would be helpful > Thanks again > James Schmidt
Fri, 09 Jul 2004 01:28:27 GMT

James Schmid #6 / 6	Here is a teaser for me DSL was down , It worked Great Thank you. Quote: > James, > format>conditional formatting > in the formula is box put > =LEN(TRIM(A1))=8 > click the format button, select patterns and colour red, > click add and formula is > =LEN(TRIM(A1))=6 > click the format button, select patterns and blue, > click OK. > -- > Regards, > Peo Sjoblom - Hide quoted text - - Show quoted text - Quote: > > How do you make a cell turn yellow if the amount of characters ( not > > numbers ) in the cell = 8 > > and blue if cell = 6 > > example #2813913 = color yellow > > example #31967 = color blue > > I have used conditional programming in the past, but only referenced numbers > > or formulas, not characters. > > -- > > Thank you, > > James P. Schmidt
Sat, 10 Jul 2004 08:52:13 GMT

Page 1 of 1

[ 6 post ]