Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I format a row depending on the value of a cell in the row | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Change decimal format of cells depending on conditions? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |