Expand Conditional Formatting to all Rows
in [General]
|
Prev: How to change order of drop lines relative to the plotted data in Excel 2007 chart
Next: Re-open worksheet saved as PDF?
From: KKD on 1 Apr 2010 12:46 I'm actually asking a different question. How do I expand the formatting I have to apply to each individual row? I can get one row to work, but short of copying this 2000 times, I don't know how to make this rule apply to each row. -- KKD "trip_to_tokyo" wrote: > KKD, check this out as I think it may assist. > > EXCEL 2007 take the following actions:- > > 1. Go into F 1 Help Facility and type in:- > > conditional formatting > > 2. Hit the Search, "button". > > 3. There is a topic called:- > > Conditionally formatted data: Examples and guidlines > > 4. Click on the above topic. > > 5. Opening the above topic there is a hyperlink about three quarters of the > way down the page called:- > > Conditional Formatting Samples > > 6. Click on the above hyperlink. > > 7. A file will open. > > Take a look at the Worksheet called:- > > Products3 > > This is about:- > > "Shade an entire row where several criteria must be true" > > This seems to be what you want. > > I have worked through this example myself and it is, "spot on". > > Please hit Yes if my comments have helped. > > Thanks. > > > > > > > > > > > > "KKD" wrote: > > > I cannot get my conditional formatting rule to apply to my entire data set. > > My data are set in rows. > > I want the entire row to format (color fill) when two specific cells within > that row equal each other. > > I can get the single row to work properly, but I can't see how to expand > this formula down to each row on my worksheet. > > > > I have read several other posts regarding this issue but am still not able > > to get it to work, can someone help me out? > > -- > > KKD
From: Gord Dibben on 1 Apr 2010 13:03 In NameBox type A1:M2000 and hit Enter. Then CF>Formula =$B1=$H1 Note the $ signs. Format to a color and hit OK Gord Dibben MS Excel MVP On Thu, 1 Apr 2010 09:20:01 -0700, KKD <KKD(a)discussions.microsoft.com> wrote: >No I have not, and what would I do with this paint brush? I want to use >conditional formatting.
From: trip_to_tokyo on 1 Apr 2010 13:14
Apply the Conditional Formatting to the range. "KKD" wrote: > I'm actually asking a different question. How do I expand the formatting I > have to apply to each individual row? > > I can get one row to work, but short of copying this 2000 times, I don't > know how to make this rule apply to each row. > -- > KKD > > > "trip_to_tokyo" wrote: > > > KKD, check this out as I think it may assist. > > > > EXCEL 2007 take the following actions:- > > > > 1. Go into F 1 Help Facility and type in:- > > > > conditional formatting > > > > 2. Hit the Search, "button". > > > > 3. There is a topic called:- > > > > Conditionally formatted data: Examples and guidlines > > > > 4. Click on the above topic. > > > > 5. Opening the above topic there is a hyperlink about three quarters of the > > way down the page called:- > > > > Conditional Formatting Samples > > > > 6. Click on the above hyperlink. > > > > 7. A file will open. > > > > Take a look at the Worksheet called:- > > > > Products3 > > > > This is about:- > > > > "Shade an entire row where several criteria must be true" > > > > This seems to be what you want. > > > > I have worked through this example myself and it is, "spot on". > > > > Please hit Yes if my comments have helped. > > > > Thanks. > > > > > > > > > > > > > > > > > > > > > > > > "KKD" wrote: > > > > > I cannot get my conditional formatting rule to apply to my entire data set. > > > > My data are set in rows. > > > > I want the entire row to format (color fill) when two specific cells within > > that row equal each other. > > > > I can get the single row to work properly, but I can't see how to expand > > this formula down to each row on my worksheet. > > > > > > I have read several other posts regarding this issue but am still not able > > > to get it to work, can someone help me out? > > > -- > > > KKD |