Entered as a Conditional Formatting formula.....

=A1="????".........then format to choice

Vaya con Dios,
Chuck, CABGx3




"L S" wrote in message
oups.com...
Ok, I have a table that already has conditional formatting on columns
E:H. My table has a subtotal on it. I am trying to keep a private
record of my stock stuff, so heres a snippet of my table:

A - H
1 Stk Symbol - other headers
2 ADP 'other info
3 ADP 'other info
4 ADP Total
5 AMAT 'other info
6 AMAT 'other info
7 AMAT 'other info
8 AMAT Total

Ok, I have a table that already has conditional formatting on columns
E:H. I am trying to do a conditional format for whenever $A1 is greater
than ???? (no stock symbol has more than four characters) I want to
format the whole row's background to be gray. How can I do this?
I've tried several different formulas over several hours, then tried
=COUNTBLANK($A1)<"????*" but it takes away my other conditional
formatting and colors every cell gray. What can I do?

Thanks for your time.
LS