Condtional format of row depending on string value of $A2 +

[L S]

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

 

[CLR]

Entered as a Conditional Formatting formula.....

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

Vaya con Dios,
Chuck, CABGx3

 

[L S]

I tried it, and it worked well. Bad thing is that it turns off my other
conditional formatting. How about we somehow create an IF statement
that if $A1 contains the string "total" we only conditionally format
that particular line? That way it would not mess with the "other info"
conditional formatting. How could I go about doing that?

 

[Bob Phillips]

Setup more than 1 condition in your CF, just make sure the highest priority
one is first.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[RagDyeR]

How about posting *exactly* the formula that you're *presently* using in the
"Conditional Format", so that we might know what revisions might work for
you.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

I tried it, and it worked well. Bad thing is that it turns off my other
conditional formatting. How about we somehow create an IF statement
that if $A1 contains the string "total" we only conditionally format
that particular line? That way it would not mess with the "other info"
conditional formatting. How could I go about doing that?

 

[L S]

Ok, here's my original conditional formulas (coming from 2 macros
written a while back):
Both of these format the numbers in E:H

Condition 1: (1 macro)
Cell value is < 0 color text red

Condition 2 and 3: (1 macro)
Cell value between 0.000001 and 0.01 color green
Cell value greater than 0.06 color yellow

These two macros work fine together.
Ok I just got a formula to work for the total lines- in every total
line column B is blank, so I just said =$B3=""
Unfortunately, the numbers in E:H lose the conditional formatting that
was stated earlier. I can run one of those macros again, but it goes
over the Total line formatting.
Is there a way to combine all of these things? Thanks again for your
help.

 

[RagDyeR]

What you're looking for is to have *more* then 3 Conditional Formats.

First off, check out this link of John McGimpsey's:

http://www.mcgimpsey.com/excel/conditional6.html

This will show you how to use XL's formatting codes (*not* Conditional
Formatting) to color your displays according to the value in the cell.

Then, you can use Conditional Formatting to format the Pattern color of the
row based on the contents of Column A.

=LEN($A1)>4

The Conditional Formatting (row colored Grey) will *not* override XL's
formatting codes.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Ok, here's my original conditional formulas (coming from 2 macros
written a while back):
Both of these format the numbers in E:H

Condition 1: (1 macro)
Cell value is < 0 color text red

Condition 2 and 3: (1 macro)
Cell value between 0.000001 and 0.01 color green
Cell value greater than 0.06 color yellow

These two macros work fine together.
Ok I just got a formula to work for the total lines- in every total
line column B is blank, so I just said =$B3=""
Unfortunately, the numbers in E:H lose the conditional formatting that
was stated earlier. I can run one of those macros again, but it goes
over the Total line formatting.
Is there a way to combine all of these things? Thanks again for your
help.

 

[L S]

Thanks for the help! After some tweaking to the old macros, I've gotten
everything up and running smoothly. That site really helped. Thanks
again!

 

[Ragdyer]

Appreciate the feed-back, and I'm sure so does J.E.