Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can someone help me with this problems please? GORD YOUR A STAR :) thnx BUTTTTTT!
is there a auick qay i can do multiple lines and apply the same
condition to them all without doing them 1 at a time? :) ---------------------------------------------- Posted with NewsLeecher v1.0 beta 23 * Binary Usenet Leeching Made Easy * http://www.newsleecher.com/?usenet ---------------------------------------------- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can someone help me with this problems please? GORD YOUR A STAR :)thnx BUTTTTTT!
You could do one row and then copy it.
then select the other rows and do edit|paste special|and click formats. But you'll want to change the formul so that it looks at the current row. =$A$1="debbie" will become: =$A1="debbie" So when you paste, excel will adjust that row number to match the current row--just like when you copy a formula. But since you're going to adjust the formula, you might as well get all the range at once: Select your range (A1:X999 include all the columns and rows you want formatted) Then format|conditional formatting Write your formula for the active cell: =$A1="debbie" When you hit ok, excel will adjust the formula for each cell in the selection. Just like when you select a multicell range and type a formula and hit ctrl-enter instead of just enter. The $A says to never adjust that column in the formula. The 1 doesn't have a $ sign. It gets adjusted. (You can read more about this stuff in Excel's help. Look for: Address then click on "About cell and range references" in the topic box DEBBZ : wrote: is there a auick qay i can do multiple lines and apply the same condition to them all without doing them 1 at a time? :) ---------------------------------------------- Posted with NewsLeecher v1.0 beta 23 * Binary Usenet Leeching Made Easy * http://www.newsleecher.com/?usenet ---------------------------------------------- -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Attn Gord Dibben | New Users to Excel | |||
go to a particular sheet Gord Dibben | Excel Worksheet Functions | |||
For Gord or other: dynamic comment | Excel Discussion (Misc queries) | |||
Question for Gord D | Excel Discussion (Misc queries) | |||
A question for Gord Dibben | Excel Discussion (Misc queries) |